Category Archives: Microsoft Excel

Updated PingCell Function for Excel

Published by:

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

I’ve updated my Microsoft Excel PingCell code that I published previously. 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.
Continue reading

Creating an SMS 2003 CCR within Excel

Published by:

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

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.
Continue reading

Generating a List of Values in Excel (VBA)

Published by:

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author.

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.
Continue reading