Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Office - Scripting Blog [archived]

How Can I Update and Then Break All the Links in an Excel Spreadsheet?

September 13, 2007 Sep 13, 2007 09/13/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I open an Excel spreadsheet, update all the links to other Excel spreadsheets, and then break those links?-- YH(image) (image) (image) Hey, YH. Before we begin, we’d like to make an announcement: the Scripting Guy who writes this column gives up. To tell you the truth, that’s not something we ever ...

How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

September 12, 2007 Sep 12, 2007 09/12/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files?-- BR(image) (image) (image) Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch as the Washington Huskies dismantled Boise State 24-10, ...

How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?

September 6, 2007 Sep 6, 2007 09/6/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I get a list of all the email addresses in my Sent Items and then write those addresses to an Excel spreadsheet?-- RD(image) (image) (image) Hey, RD. As a matter of fact, yes, we are having problems focusing on work today. Granted, that’s true most days. However, at least today it’s understandable, ...

How Can I Add a Background Picture to an Excel Worksheet?

September 5, 2007 Sep 5, 2007 09/5/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA(image) (image) (image) Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his daily doughnut. (But don’t worry: it’s a medically-...

How Can I Get a List of Appointments for a Specific Month?

August 29, 2007 Aug 29, 2007 08/29/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I get a list of my appointments for a specific month (for example, all my appointments for December, 2007)?-- HG (image) (image) (image) Hey, HG. We’ll get to your question in just a moment. Before we do that, however, the Scripting Guy who writes this column wants to take a little time and enjoy the ...