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

Hey, Scripting Guy! How can I get the names of 10 randomly-selected files in a folder? I need to do that so I can test and verify our backup and restore policies.-- CS Hey, CS. You know, if you’re interested in things that are random, haphazard, arbitrary, or downright chaotic, well, you came to the right place. For example, any time we Scriptin...

Hey, Scripting Guy! How can I find text in a Word document that has been highlighted in a particular color (say, turquoise), and then both remove the highlight and change the font color of that text to something else (say, blue)? I’d be extremely chuffed if you can solve this one!-- KB Hey, KB! Blimey! You know, when we first saw your message we...

Hey, Scripting Guy! How can I add a COUNTIF formula to an Excel spreadsheet?-- MF Hey, MF. Thanks for reminding us: yes, we are getting closer and closer to the actual 500th Hey, Scripting Guy! Celebration. Note. There was a bunch of stuff here about the celebration, but it’s over now so we took it out. That should explain the small gap in...

Hey, Scripting Guy! How can I determine last month’s date? I need to be able to take the month and year for the previous month (using the format mmyy) and create a file name like this: test0606.xls.-- DR Hey, DR. We have to admit that, at first, this question posed a bit of a problem for the Scripting Guys. Not because this is an especially toug...

Hey, Scripting Guy! How can I load list box options from a text file?-- MV Hey, MV. You would have to mention “options,” wouldn’t you? When the Scripting Guy who writes this column first joined Microsoft some five years ago, he assumed that he’d work for two or three years, cash in all his stock options, and then spend the rest of his life lazin...