Showing results for July 2007 - Page 4 of 4 - Scripting Blog [archived]

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 Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his professional efforts to “lifelogging,” an a...

Hey, Scripting Guy! How can I set the print area in an Excel spreadsheet?-- PRP 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’s because he didn’t want to make any ...

Hey, Scripting Guy! How can I loop through a 12x12 array and replace any null values with a hyphen?-- AM 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 with their fellow Microsoft employees,...

Hey, Scripting Guy! How can I change the local Administrator password on all the computers in my domain?-- AO 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 care if anyone thinks he’s a dog or not; in fa...

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 Hey, R. You, from time-to-time people write to the Scripting Guys and say, “You guys a...