Anyway, I finally decided it was time to automate this portion of the process so I couldn't forget it. It took a while, but here are the results. Note that this code is from VB6, but it should work equally well from any VB/VBA type environment:
provided by Julian Robichaux at nsftools.com.
Sources: Xtreme Visual Basic Talk, Microsoft Knowledgebase