Scripting Blog [archived]

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

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

(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?

(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?

(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?

(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 ...