Scripting Blog [archived]

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

How Can I List All the Fields and Data Types in an Access Database?

(image) Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field?-- MF (image) (image) (image) Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his ...

How Can I Set the Print Area in an Excel Spreadsheet?

(image) Hey, Scripting Guy! How can I set the print area in an Excel spreadsheet?-- PRP (image) (image) (image) Hey, PRP. You know, before the Scripting Guy who writes this column wrote his very first column he took a sacred vow: he vowed never to take a sacred vow, at least not when it came to writing the Hey, Scripting Guy! column. That...

How Can I Replace Null Values in an Array?

(image) Hey, Scripting Guy! How can I loop through a 12x12 array and replace any null values with a hyphen?-- AM (image) (image) (image) Hey, AM. Sorry for the delay in getting back to you; as it turns out, yesterday was Independence Day (more typically referred to as the Fourth of July) in the good old USA, and the Scripting Guys, along ...

How Can I Change the Local Administrator Password on All My Computers?

(image) Hey, Scripting Guy! How can I change the local Administrator password on all the computers in my domain?-- AO (image) (image) (image) Hey, AO. You know, according to the now-classic cartoon punch-line, “on the Internet, no one knows if you’re a dog.” To be perfectly honest, the Scripting Guy who writes this column doesn’t ...

How Can I Create a Folder With a Name Based on the Monday and Friday of the Coming Week?

(image) Hey, Scripting Guy! Every Sunday I need to create a folder with a name similar to this: C:\Test\7-2-2007 to 7-6-2007, with the dates representing the Monday and the Friday of the upcoming week. How can I write a script that will create this folder for me?-- R (image) (image) (image) Hey, R. You, from time-to-time people write to ...