Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Office   (RSS)
Thursday, May 14, 2009 8:23 PM

Hey, Scripting Guy! How Can I Use Windows PowerShell to Look for and Replace a Word in a Microsoft Word Document?

Hey, Scripting Guy! The week of April 17, 2009 , you did a weeklong series of “Hey, Scripting Guy!” articles on regular expressions. I tried to change one of your scripts to open an office Word document that uses Windows PowerShell to look for a particular
Posted by ScriptingGuy | 0 Comments
Wednesday, May 13, 2009 8:22 PM

Hey, Scripting Guy! How Can I Convert to Windows PowerShell a VBScript Script That Creates a Table in Office Word?

Hey, Scripting Guy! I was looking through the Office Space Archive and came across a nice article that talks about how to create a table in Office Word . The article is interesting, but I am more interested in how to do this by using Windows PowerShell.
Posted by ScriptingGuy | 0 Comments
Thursday, February 19, 2009 6:15 PM

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does
Posted by ScriptingGuy | 0 Comments
Monday, February 16, 2009 6:12 PM

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better.
Posted by ScriptingGuy | 0 Comments
Thursday, January 29, 2009 6:02 PM

Hey, Scripting Guy! How Can I Display My Office Outlook Appointments Without Starting Office Outlook?

Hey, Scripting Guy! I live and I die by my Office Outlook calendar. But Office Outlook sometimes seems to be rather slow when I am logging on first thing in the morning. When I have to boot up my laptop, log on to the network, start Office Outlook, and
Posted by ScriptingGuy | 0 Comments
Tuesday, January 27, 2009 6:01 PM

Hey, Scripting Guy! How Do I Determine How Many Office Outlook E-Mail Messages I Sent in a Week?

Hey, Scripting Guy! The Pointy Headed Boss (PHB) just got back from some kind of stupid management summit, and he has decided he needs to track our work activities more closely. As a result, we now have to give him a weekly progress report. Seems to me
Posted by ScriptingGuy | 0 Comments
Monday, January 26, 2009 6:00 PM

Hey, Scripting Guy! How Do I Use Windows PowerShell to Work with Junk E-Mail in Office Outlook?

Hey, Scripting Guy! I need to find out how many e-mail messages are in my Junk folder. I found a script that does this with VBScript, but I need to be able to do it in Windows PowerShell. I do not want to delete the junk e-mail, because there are times
Posted by ScriptingGuy | 0 Comments
Thursday, January 15, 2009 8:56 AM

Hey, Scripting Guy! How Can I Modify the Footers of an Office Excel Spreadsheet?

Hey, Scripting Guy! I have a simple question for you: How can I modify the footers in an Office Excel spreadsheet? - MN Hi MN, I have a simple answer for you as well. You assign a value to the appropriate footer property of the pagesetup object. If you
Posted by ScriptingGuy | 0 Comments
Wednesday, January 14, 2009 8:55 AM

Hey, Scripting Guy! How Do I Center Contents of a Column in Office Excel?

Hey, Scripting Guy! When I add data to an Office Excel spreadsheet, it always seems to put stuff on the right side of the column. I would like to know how to center the contents of a column. I do not think it should be that hard, but I just cannot figure
Posted by ScriptingGuy | 0 Comments
Tuesday, January 13, 2009 8:55 AM

Hey, Scripting Guy! How Do I Run an Office Excel Macro on Multiple Workbooks?

Hey, Scripting Guy! I don't know about you, but I love Microsoft Office Excel macros. Come Valentine's Day , my computer gets a card. Office Excel macros save me so much time, it is just unbelievable. There is just one problem, and that is that I have
Posted by ScriptingGuy | 0 Comments
Monday, January 12, 2009 8:54 AM

Hey, Scripting Guy! How Can I Add a Function to an Office Excel Spreadsheet?

Hey, Scripting Guy! I need to add some data to an Excel spreadsheet. After I have done that, I would like to add a function to the bottom that will add up all the information in the columns above that. I have seen examples of plugging data into cells,
Posted by ScriptingGuy | 0 Comments
Friday, January 09, 2009 9:30 PM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/09/09)

How Can I Tell the Status of Services on a Computer? Hey, Scripting Guy! I’m wondering if you can help me before I tear all my hair out. I’m trying to write a script using WMI that checks for a few core services such as antivirus, remote desktop software,
Posted by ScriptingGuy | 0 Comments
Thursday, November 13, 2008 8:19 AM

Hey, Scripting Guy! How Can I Count How Many Images Are Embedded in Microsoft Word Documents?

Hey Scripting Guy! You are not going to believe this. I have just been given the task of counting how many images are embedded in Word documents. The document folder, of course, has hundreds of documents. I am not sure why they want to know how many documents
Posted by ScriptingGuy | 0 Comments
Wednesday, November 12, 2008 8:19 AM

Hey, Scripting Guy! How Can I Convert Word Files to PDF Files?

Hey, Scripting Guy! I have a folder full of Word documents. The pointy-headed boss (PHB) is being particularly obtuse this week, and has decided that he would like to have all the Word documents turned into PDF files so everyone can view them. This is
Posted by ScriptingGuy | 0 Comments
Tuesday, November 11, 2008 8:18 AM

Hey, Scripting Guy! How Can I Create a Microsoft Word Document from WMI Information?

Hey Scripting Guy! I would like to be able to use Windows PowerShell to obtain some information from WMI and then write that same information to a Microsoft Word document. I know that I can use Out-File to create a text file, but text files are boring.
Posted by ScriptingGuy | 0 Comments
More Posts Next page »
 
Page view tracker