Scripting Blog [archived]

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

How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?

(image) Hey, Scripting Guy! How can I delete data from a spreadsheet yet keep all the formatting?-- TB(image) (image) (image) 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 ...

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

How Can I Insert Files into a Word Document?

(image) 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(image) (image) (image) Hey, HK. Believe it or not it’s actually easier to insert files into a Microsoft Word document than it is...