I've tried to use a number of items to get the proper path
to the Excel spreadsheet that is opening but I keep missing.
Sometimes the Excel spreadsheet takes it's own path from
a previously opened spreadsheet. Sometimes it takes it
from a parameter at:

Tools, Options..., General tab, Default File Location:

Specifically I am using VBA and trying to use:
ThisWorkbook.Path but that is giving the results above.

I need the correct path for the workbook / spreadsheet
file that is opening up. How do I get that path?

Thank you very much in advance. :-)

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!