Showing archive results for 2006

Hey, Scripting Guy! We have an Excel spreadsheet that tracks the status of all our projects. In that spreadsheet the status for a project is indicated by a color assigned to a cell. How can I use a script to determine the color of these cells?-- AE Hey, AE. Just a second; we need to catch our breath. Sorry. Last night the Scripting Guy who write...

Hey, Scripting Guy! How can I run a Windows PowerShell script from the Run dialog box or from a shortcut? In the Run dialog box I type something like c:\scripts\test.ps1 but my script just opens up in Notepad.-- RS Hey, RS. We have just one thing to say: University of Washington 29, UCLA 19. And this after the Huskies trailed 16-0 late in the fi...

Hey, Scripting Guy! How can I insert text into an existing Microsoft Word bookmark?-- WM Hey, WM. Believe it or not, this turned out to be the most difficult script the Scripting Guy who writes this column has ever had to create. Not because the script itself is very hard; as you’re about to see, it’s not. Instead, for some bizarre reason the Sc...

Hey, Scripting Guy! I have a dumb question for you: If I have two lists how can I verify that all the items in list 2 can be found in list 1?-- SS Hey, SS. Trust us; we’ve heard sillier questions. For example, awhile back the Scripting Son came downstairs on a Saturday morning to find the Scripting Dad eating breakfast. “What’s that?” he said, p...

Hey, Scripting Guy! In an Excel worksheet, how can I make the first character in each cell uppercase and the remaining letters in each cell lowercase?-- DW Hey, DW. To begin with, we hope you had a happy holiday season; you didn’t eat too much turkey, did you? As for the Scripting Guys, we all – oh, sorry. Silly us; we made the mistake of lookin...