Monthly Archives: May 2009

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

Microsoft Office Registered User Setup via Script

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.

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