Quote Originally Posted by Kenneth Hobson View Post
The best way to handle that is to pass a command line parameter for one of the methods. If you don't know how to do this, see these examples. The last one is a shorter method than some others.

http://support.microsoft.com/kb/291288

http://office.microsoft.com/en-au/ex...580301033.aspx

http://www.dailydoseofexcel.com/arch...uments-in-vba/

http://www.pcreview.co.uk/forums/thread-2004448.php

http://www.j-walk.com/ss/excel/eee/eee002.txt

http://www.vbforums.com/showthread.php?t=366559
Thank you. I'm going to review these links and adapt to my needs.