Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?

April 24, 2006 Apr 24, 2006 04/24/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I select a column of data in Excel and then paste that data into a text file?-- GT(image) (image) (image) Hey, RR. You know, if you’re like most people, any time you hear the words “Scripting Guys” you undoubtedly think of two things: elegance and sophistication. Despite our well-deserved ...

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 Save an Excel Spreadsheet, and Then Save a Copy as HTML?

March 7, 2006 Mar 7, 2006 03/7/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I save an Excel spreadsheet, and then save a copy of that spreadsheet as HTML?-- TH(image) (image) (image) Hey, TH. You know, it’s interesting that you used the word “save” in your question. After all, the Scripting Guy who writes this column (who’s much lazier - um, much busier than usual) just ...

How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?

February 23, 2006 Feb 23, 2006 02/23/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I format an Excel spreadsheet so that it retains leading zeroes?-- AS(image) (image) (image) Hey, AS. You know, one of the Scripting Guys still has nightmares about the number zero. Several years ago he got a phone call from a friend of his wondering if he’d be interested in helping coach a youth ...