Scripting Blog [archived]

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

How Can I Get a List of All the PDF Files in a Folder and Its Subfolders?

(image) Hey, Scripting Guy! How can I get a list of all the .PDF files (only the file names; I don’t want the file path or file extension) in a folder and its subfolders, and then put that list into a text file?-- PS (image) (image) (image) Hey, PS. You know, PS, this is actually a hard question; far harder and far more complicated than ...

How Can I Create a Shortcut For an Executable File That Uses Parameters?

(image) Hey, Scripting Guy! How can I create a shortcut where the target path is an executable file that uses parameters (for example, something.exe -t –s)?-- MC (image) (image) (image) Hey, MC. A week or so ago we mentioned that we were going to make some changes to Hey, Scripting Guy!; in particular, we were going to stop wasting time ...

How Can I Add a Page X of Y Footer to a Microsoft Word Document?

(image) Hey, Scripting Guy! I saw your article on adding page numbers to the footer of a Word document. However, I need my page numbers to be in the format "Page X of Y," where X is the current page number and Y is the total number of pages. How can I do that?-- JS (image) (image) (image) Hey, JS. You know, several years ago the grocery ...

How Can I Append a Value to a Specified Field For Each Record in a Database?

(image) Hey, Scripting Guy! How can I add the letter s to the end of a specified field for each record in an Access database?-- A (image) (image) (image) Hey, A. It’s day 2 of TechEd 2007 and the Scripting Guys are still sitting here in the CMP Media booth (that’s booth No. 1301 for those of you attending TechEd); they’re busy ...

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

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