I would love to have this as a stand alone application in vb, however I am restricted to use vba/excel, as it runs against our work policy.

The 'set new app....' looks like it will work well. I will try that out and see what happens.