Scripting Blog [archived]

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

How Can I Get a List of Available Metadata for Microsoft Office Documents?

(image) Hey, Scripting Guy! How can I get a list of available metadata for Microsoft Office documents?-- JR (image) (image) (image) Hey, JR. If we understand your question correctly, you’d like to know if it’s true that July 21, 2006 will mark the 500thHey, Scripting Guy! column; in addition, you’d like to know whether we ...

How Can I Create a New Excel Spreadsheet at Midnight Each Night?

(image) Hey, Scripting Guy! How can I create a new Excel spreadsheet at midnight each night? I’d like each spreadsheet to have a file name similar to this: 6-1-06.xls.-- DH(image) (image) (image) Hey, DH. You know, often-times the simplest approach is also the best approach. For example, the other night the Scripting Son was having a ...

How Can I Change the Footer in an Excel Spreadsheet?

(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 Copy Column C of One Worksheet to Column A of a Second Worksheet?

(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?

(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...