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.
I frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists.
Read my review of RoboForm here.