Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! How Do I Migrate My VBScript WMI Queries to Windows PowerShell?

We are pretty well annoyed at you guys. We spent all this time and energy creating all these VBScripts over the last nine years. We have several hundred VBScripts that we use in production, and with uncertain economic times, you are now telling me I have to rewrite all these scripts in Windows PowerShell? Most of these scripts use WMI, which...

Hey, Scripting Guy! How Can I Delete Files That Are a Specified Number of Hours Old?

Hey, Scripting Guy! I’ve seen scripts that let you delete all the files in a folder that are X number of days old. I have a different problem: I’d like to delete files that are X number of hours, or even X number of minutes, old. How can I do that?-- DF Hey, DF. Did you see where some researchers are predicting that, by the year 2050, ...

How Can I Identify the Last File in a Sequential List of Files?

Hey, Scripting Guy! I have a folder which contains thousands of files, all numbered sequentially. How can I tell which file is the last file in the list?-- AC Hey, AC. You know, one of the fun things about being a Scripting Guy is that we get to spend a lot of time shattering myths. For example, when we first started at Microsoft there was ...

How Can I Get a Total Page Count for All the Word Documents in a Folder?

Hey, Scripting Guy! How can I get a total page count for all the Word documents in a folder?-- RA Hey, RA. You’ll have to forgive the Scripting Guy who writes this column if he seems a little tired this morning. Yesterday was the first day of school in the Lake Washington School District and, as you might expect, the scene in the ...

How Can I Remove Blank Spaces From File Names?

Hey, Scripting Guy! I have a folder with a bunch of files in it, files with names like Doc 1.pdf, Doc 2.pdf, and Doc 3.pdf. How do I remove the blank spaces from all those file names?-- JRP Hey, JRP. You know, today’s column represents a landmark in Hey, Scripting Guy! history. Why’s that? Because the Scripting Guy who writes this ...

Feedback usabilla icon