Scripting Blog [archived]

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

ActiveX Data Objects (ADO) - Scripting Blog [archived]

How Can I List All the Tables in an Access Database?

June 8, 2006 Jun 8, 2006 06/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I list all the tables in an Access database?-- KW(image) (image) (image) Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours, dead-ends, and other frustrations we go through in order ...

How Can I Query a Text File and Retrieve Records That Occurred on a Specific Date?

May 4, 2006 May 4, 2006 05/4/06
ScriptingGuy1
(image) Hey, Scripting Guy! We have tons of text files in which each line in the file represents a record or an event of some kind. How can I use a script to retrieve records or events that occurred on a specified date?-- TW(image) (image) (image) Hey, TW. You know, in your email you sort of apologized for using text files, noting that “...

How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

April 6, 2006 Apr 6, 2006 04/6/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB(image) (image) (image) Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for ...

How Can I Get a List of All the Users Who Have an Alternate Recipient?

March 22, 2006 Mar 22, 2006 03/22/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I get a list of all the users who have an alternate recipient (altRecipient)?-- SA(image) (image) (image) Hey, SA. You know, one of the great things about being a Scripting Guy is that we don’t ever have to know what we’re talking about; all we do have to know is how to write a script that does ...