Scripting Blog [archived]

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

Excel.Application - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?

January 26, 2007 Jan 26, 2007 01/26/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML?-- KE (image) (image) (image) Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for the movers to come in and clear everything out...

Hey, Scripting Guy! How Can I Set the Default File Path in Office Excel to a User’s Home Directory?

January 16, 2007 Jan 16, 2007 01/16/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I set Office Excel’s default file path to a user’s home directory?-- LL (image) (image) (image) Hey, LL. We hope that the script we’re about to show you will answer your question; if it doesn’t, you might have to wait awhile before we can get back to you on it. That’s because...

How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?

December 7, 2006 Dec 7, 2006 12/7/06
ScriptingGuy1
(image) Hey, Scripting Guy! In Excel, how can I compare a list of names found in one column with a list of names found in another column?-- GS(image) (image) (image) Hey, GS. You know, in general we Scripting Guys are charged with presenting people with facts; in turn, we’re really supposed keep our opinions to ourselves. However, ...

How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?

December 5, 2006 Dec 5, 2006 12/5/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert a tilde-delimited file to Microsoft Excel format?-- JN(image) (image) (image) Hey, JN. You know, to tell you the truth we’re beginning to rethink our approach to this column. After all, usually we tell people how easy things are, and how – without much effort – they can write a script that ...

How Can I Add a Total Row to an Excel Spreadsheet?

November 15, 2006 Nov 15, 2006 11/15/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add a bunch of rows to an Excel spreadsheet and then stick a total row at the bottom?-- MW(image) (image) (image) Hey, MW. Could we ask you a favor: is there any chance that you could write back later with this question? As you may or may not know, the University of Washington men’s basketball team is ...