Showing results for Excel.Application - Scripting Blog [archived]

Hey, Scripting Guy! How can I get a list of available metadata for Microsoft Office documents?-- JR 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 are planning to do anything to mark th...

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 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 frustrating baseball game: in his first tw...

Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet?-- JA 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 can change all three of them:Set objExcel =...

Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP 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, right: you wanted to know how to do thi...

Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets?-- JG 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.) Eventually one of us spoke up and sai...