The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.
New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.
(image)
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(image) (image) (image)
Hey, CS. You know, if you’re interested in things that are random, haphazard, arbitrary, or downright chaotic, well, you came to the right ...
(image)
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(image) (image) (image)
Hey, KB! Blimey! You ...
(image)
Hey, Scripting Guy! How can I add a COUNTIF formula to an Excel spreadsheet?-- MF(image) (image) (image)
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 ...
(image)
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(image) (image) (image)
Hey, DR. We have to admit that, at first, this question posed a bit of a problem for the Scripting Guys...
(image)
Hey, Scripting Guy! How can I load list box options from a text file?-- MV(image) (image) (image)
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 ...