Scripting Blog [archived]

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

VBScript - Scripting Blog [archived]

How Can I List All the Files on a User’s Desktop?

April 10, 2006 Apr 10, 2006 04/10/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I list all the files on a user’s desktop?-- BT(image) (image) (image) Hey, BT. So you thought you could fool the Scripting Guys, did you? Well, you did, at least for awhile. As is so often the case with the Scripting Guys we took one look at your question and thought, “Let’s answer this one; this ...

How Can I Convert a Number to a Date in Excel?

April 7, 2006 Apr 7, 2006 04/7/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert a number in Excel to a date; for example, how can I convert 40806 to 4/8/2006?-- JM(image) (image) (image) Hey, JM. You probably didn’t know this, but one of the Scripting Guys has a brother who’s an actor. As every actor knows, nepotism is pretty prevalent in the acting world. Well, it’s...

How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

April 6, 2006 Apr 6, 2006 04/6/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB(image) (image) (image) Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for ...

How Can I Determine the Path to the Folder Where a Script is Running?

April 5, 2006 Apr 5, 2006 04/5/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine the path to the folder where a script is running? What I’d like to do is have the script automatically open the folder where the script is running.-- PD(image) (image) (image) Hey, PD. You know, for the Scripting Guys this question - as do so many of the questions we receive - falls under ...