Showing results for Office - Scripting Blog [archived]

Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet?-- SK Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started planning the 2008 Winter Scripting Games (February 15th through March 3rd, right here in the ...

Hey, Scripting Guy! I have a bunch of Word documents in a folder. I need to open each document, read in some information from the first two lines, then use that information to rename the file. However, I’m having some trouble getting this to work. Can you help me?-- TG Hey, TG. As devoted readers of Hey, Scripting Guy! know, the Scripting Guy wh...

Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB Hey, AB. Before we start ...

Hey, Scripting Guy! We have an application that repeatedly runs a test and writes the result of each test pass to a Microsoft Word document. Periodically I’d like to be able to use a script to tally up the number of times a test passed, the number of times a test failed, and the number of times a test failed to run. How can I write a script like ...

Hey, Scripting Guy! How can I reset the revision number of a Microsoft Word document back to 1?-- JL Hey, JL. You know, a lot of people think the Scripting Guys have lost their edge. “You guys used to write all these crazy scripts that used all these weird and wacky workarounds in order to solve problems,” they say. “Now you just write boring ol...