scripting
-
Refresh Many Excel Reports Automatically
Today I’d like to share a little homemade tool I whipped up to save me the tedious yet trivial recurring chore of opening several Excel workbooks and clicking the Refresh button inside each one.
-
Sort files in bulk with PowerShell
I want to find more time to learn PowerShell from the ground up. So far I’ve been scripting with it and learning chunks and cmdlets at a time as I need them. For example:
-
Set Microsoft Office Name for Friendlier File in Use Messages
Has this ever happened to you? At best an annoyance, this can be a real productivity killer as you hunt around to find the user that has the file locked. You could save a copy of the file and try to clean up or reconcile later, and while collaboration solutions like SharePoint limit these cases, most businesses still rely heavily on network storage that makes this impractical. So, help make the word — or at least your office — a better place: click here and open this small vbscript file, which will set your Microsoft Office name to match your company’s network…