Scripting Blog

A place to learn about PowerShell and share stories of automation

Office - Scripting Blog

How Can I Add a Hyperlink to a Word Document?

February 15, 2005 Feb 15, 2005 02/15/05
ScriptingGuy1
Hey, Scripting Guy! How can I add a hyperlink to a Word document?-- BA Hey, BA. Interesting question; in thinking about common tasks for scripting Microsoft Office applications we never even considered adding a hyperlink to a document. (Needless to say, that’s why we rely on people like you to let us know about the tasks people really ...

How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?

January 31, 2005 Jan 31, 2005 01/31/05
ScriptingGuy1
Hey, Scripting Guy! How can I open an existing Excel spreadsheet, add some additional information to that spreadsheet, and then save my changes? Every time I call the SaveAs method a dialog box pops up asking me if I want to save my changes.-- RW Hey, RW. Generally speaking, you can avoid that dialog box by using the Save method rather than...

How Can I Put the User Name into the Footer of a Microsoft Word Document?

January 11, 2005 Jan 11, 2005 01/11/05
ScriptingGuy1
Hey, Scripting Guy! How can I put the user name into the footer of a Microsoft Word document?-- RR Hey, RR. That’s an interesting question, and probably the first how-do-I-put-the-user-name-in-the-footer-of-a-Word-document question we’ve ever received. (No, really!) But what the heck; let’s see if we can find an answer for you. ...

How Can I Save Word Documents as Text Files By Using a Script?

December 22, 2004 Dec 22, 2004 12/22/04
ScriptingGuy1
Hey, Scripting Guy! I have a series of Word files. I would like to open each of these files and save them as plain-text files. Is there a way to do that using a script?-- CG Hey, CG. Yes, you can do this quite easily with a script; in fact, with very few exceptions anything you can do within a Microsoft Office program you can do by using a ...