Scripting Blog [archived]

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

How Can I Search a Word Document for All the Words in Double Brackets?

(image) Hey, Scripting Guy! How can I search a Word document for all the words in double brackets? For example, I need to find words like this: [[failed]]. I then need to save the words I find to a text file.-- PP(image) (image) (image) Hey, PP. You know, one thing that seems to be true of the Scripting Guys is a willingness to do ...

How Can I Extract Just the File Name from the Full Path to the File?

(image) Hey, Scripting Guy! How can I extract just the file name from the full path to the file?-- SD(image) (image) (image) Hey, SD. As you might know, Ted Williams was the last major league baseball player to bat .400 for an entire season. Coming into the final day of the year, Williams was actually hitting something like .3997 which, ...

How Can I Search for Folders That Have a Dot in Their Name?

(image) Hey, Scripting Guy! How can I search for folders that have a dot in their name? For example, a folder like Administrator.name or Folder.old?-- DU(image) (image) (image) Hey, DU. You know, if your intention was to trick the Scripting Guys (not that tricking the Scripting Guys would be anything to brag about), well, you almost ...

How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?

(image) Hey, Scripting Guy! How can I change all the lowercase letters in an Excel worksheet to uppercase letters?-- BC(image) (image) (image) Hey, BC. Have you ever heard the old expression, “If you want something done you have to do it yourself”? Well, to tell you the truth, we Scripting Guys had heard of that old expression, but we ...

How Can I Get a Script to Delete Itself?

(image) Hey, Scripting Guy! I have a script for installing a printer that I give to my end users. When the script finishes, I’d like it to be able to delete itself. How can I get a script to delete itself?-- EA(image) (image) (image) Hey, EA. You know, that’s an interesting idea: disposable scripts, just like disposable razors or ...