I’ve updated my Microsoft Excel PingCell code that I wrote for this post. The new function returns all results from Win32_PingStatus back to Excel. You can now ping and choose the results you’d like to see returned (example below code). The Win32_PingStatus class is documented on Microsoft’s Website.
I recently came across an issue where I need to create a hyperlink in Microsoft Word 2003 that was roughly 300 characters long. Unfortunately, it appears that Microsoft had put some odd restriction in place on the maximum length of a hyperlink and it seemed I was out of luck. After a few minutes of googling turned up nothing, I was forced to find my own solution.
I created the following function to create Microsoft SMS 2003 Client Configuration Requests from within Excel and dump them all out into a temporary directory for me to copy to the SMS inbox. For those that are unaware, you can “ask” SMS 2003 to remotely install the client by putting a CCR file into the INBOXES\CCR.BOX folder on the SMS Site server.
Oddly enough, I often find myself needing to ping a list of computers from Excel. Usually it’s part of some asset management or software deployment exercise. If it’s a small list, I’ll often do it manually. Medium and larger lists usually warrant some type of batch file hitting the list and I just keep an eye on the results or have them pipe back to a text file. Recently I developed an Excel sub that would do the work for me and then return the results back to a column for me to sort and filter by.
The following AutoIt script will allow you to set the Microsoft Office Registered User Name, Initials, and Company via a script by getting the name information from Active Directory and modifying the keys . This is useful in corporate environments where you don’t want it to have a generic name when you’re being told someone else has your file open.