Showing results for Office - Scripting Blog [archived]

Hey, Scripting Guy! How can I delete data from a spreadsheet yet keep all the formatting?-- TB Hey, TB. From your email it sounds like you have a script that periodically replaces data in a spreadsheet with new, up-to-date values. The spreadsheet has been preformatted, and what you’d like to do is delete all the old values - thus making room for...

Hey, Scripting Guy! How can I hide a specific toolbar in Microsoft Word?-- AG Hey, AG. Now this question brings back memories. When our editor joined the team one of her first actions was to make us redo a whole bunch of screenshots we had made for the Scripting Week 2 webcasts. Why? Because she didn’t think we should include screenshots that sh...

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

Hey, Scripting Guy! How can I save (to a separate file) all the paragraphs in a Word document that are formatted using a particular style, like Heading 1?-- RN Hey, RN. You know, when we first read this question we thought, “Interesting. But why would you ever want to do something like that?” And then one of the Scripting Guys remembered the man...

Hey, Scripting Guy! Awhile back you showed people how they could combine several text files into a single file. I’d like to do the same thing in Word. How can I insert files into a Word document?-- HK Hey, HK. Believe it or not it’s actually easier to insert files into a Microsoft Word document than it is to insert a text file into another text ...