Scripting Blog [archived]

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

Excel spreadsheet - Scripting Blog [archived]

How Can I Change the Footer in an Excel Spreadsheet?

December 21, 2005 Dec 21, 2005 12/21/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet?-- JA(image) (image) (image) Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script that ...

How Can I Sort Worksheets in a Workbook?

November 22, 2005 Nov 22, 2005 11/22/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I sort worksheets in a workbook?-- FS(image) (image) (image) Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process is a tiny bit ...

How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?

September 20, 2005 Sep 20, 2005 09/20/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP(image) (image) (image) Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then press Ctrl+V. There you go, and thanks for your question. Oh, ...

How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?

May 31, 2005 May 31, 2005 05/31/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets?-- JG(image) (image) (image) Hey, JG. It’s the first day back after a three-day weekend, and this morning all the Scripting Guys stumbled into the office and just stared blankly into space. (All in all, pretty much business as usual...