Scripting Blog [archived]

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

Excel.Application - Scripting Blog [archived]

How Can I Create a Custom Date Format in Microsoft Excel?

November 8, 2006 Nov 8, 2006 11/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! In Microsoft Excel, how can I display a date like 01/20/2006 using this format: 20060120?-- CM(image) (image) (image) Hey, CM. Who do we make the check out to again? And for how much? Oh, sorry. After attending a parent meeting for the Scripting Son’s new baseball team the Scripting Guy who writes this column ...

How Can I Keep the Screen From Updating While Running an Excel Script?

November 1, 2006 Nov 1, 2006 11/1/06
ScriptingGuy1
(image) Hey, Scripting Guy! I seem to recall that there’s a way to “freeze” the display in Microsoft Excel any time you carry out a lengthy operation; that way the user doesn’t see anything change until the operation is complete. Do you have any idea how I can do that?-- IW(image) (image) (image) Hey, IW. Do we have any idea of how ...

How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?

October 30, 2006 Oct 30, 2006 10/30/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I rename a bunch of folders using a script? The old folder names are in the first column of an Excel spreadsheet and the new folder names are in the second column of an Excel spreadsheet.-- SF(image) (image) (image) Hey, SF. Oh, and welcome to Hey, Scripting Guy!, your daily source for scripting ...

How Can I Use Windows PowerShell to Automate Microsoft Excel?

September 8, 2006 Sep 8, 2006 09/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW(image) (image) (image) Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce you ...

How Can I Copy a File Numerous Times and Rename Each of Them from a List in Excel?

June 27, 2006 Jun 27, 2006 06/27/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy a file 150 times and then rename each of those copies using a list of names found in an Excel spreadsheet?-- DF(image) (image) (image) Hey, DF. You know, when we first started this column 2 years ago (must be time to mention the 500th Hey, Scripting Guy! celebration again) our biggest concern was ...