Showing tag results for Office

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 add additional worksheets to an Excel workbook? By default you get 3 worksheets, but I have a scenario in which I need a workbook that has 12 worksheets.-- AA Hey, AA. You know, a couple years ago one the Scripting Guys helped put together an Excel spreadsheet for one of the local youth baseball leagues. Because the...

Hey, Scripting Guy! How can I convert an Outlook email message into a text file?-- MW Hey, MW. You know what drives the Scripting Guys crazy? (We mean besides the other Scripting Guys.) It’s this: people who barely say hello before they start making excuses: “I’m sorry I did such a lousy job on this, but ….” “I realize that I was supposed to hav...

Hey, Scripting Guy! How can I use WSH to close a command window with a specific title?-- MF Hey, MF. You know, some things are just really hard to believe, regardless of whether or not they happen to be true. For example, according to the Big Bang Theory the entire universe was created when a miniscule spec of super-dense matter exploded several...

Hey, Scripting Guy! In Microsoft Word 2003, my documents open as Final Showing Markup. How can I change this so the default view is Final?-- CD Hey, CD. You know, this is the first Hey, Scripting Guy! column we’ve written since returning from the Thanksgiving holiday. After four days of eating, football, eating, basketball, and then a little mor...