Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

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 Determine the Background Color of a Spreadsheet Cell?

September 27, 2006 Sep 27, 2006 09/27/06
ScriptingGuy1
(image) Hey, Scripting Guy! We have an Excel spreadsheet that tracks the status of all our projects. In that spreadsheet the status for a project is indicated by a color assigned to a cell. How can I use a script to determine the color of these cells?-- AE(image) (image) (image) Hey, AE. Just a second; we need to catch our breath. Sorry. ...