Scripting Blog [archived]

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

Office - Scripting Blog [archived]

How Can I Copy Selected Columns From a CSV File to an Excel File?

June 4, 2007 Jun 4, 2007 06/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file?-- MdP (image) (image) (image) Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum. Some of you might be concerned that ...

How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

May 29, 2007 May 29, 2007 05/29/07
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?-- GL (image) (image) (image) Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking their...

How Can I Export an HTA Table to Excel?

May 25, 2007 May 25, 2007 05/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I put a button in an HTA that, when clicked, exports an HTML table to Excel?-- DW (image) (image) (image) Hey, DW. You know, yesterday afternoon the Scripting Guy who writes this column went to get his hair cut, figuring he needs to look his best for TechEd 2007. (It was only after he got his hair cut ...

How Can I Save Each Paragraph in a Word Document as a Database Record?

May 23, 2007 May 23, 2007 05/23/07
ScriptingGuy1
(image) Hey, Scripting Guy! A few days ago you showed us how to open a bunch of text files and save the data in each file as a record in a database. I have a similar question, except that I want to save each paragraph in a Word document as a database record. How can I do that?-- HY (image) (image) (image) Hey, HY. Before we tackle today’...

How Can I Add the Contents of a Group of Text Files to an Access Database?

May 21, 2007 May 21, 2007 05/21/07
ScriptingGuy1
(image) Hey, Scripting Guy! I have a folder that has hundreds of text files in it. I’d like to take each of those files and add the contents (as a memo field) to an Access database. How can I do that?-- KB(image) (image) (image) Hey, KB. You know, a few years ago the Scripting Guy who writes this column gave a talk at a conference in ...