Capturing the directory when a workbook is opened from Explorer
 

I would like to be able to capture the directory that a
workbook is opened from Windows Explorer in a VB auto_open
macro. The CurDir function only works if the file was
opened using Excel.

Capturing the directory when a workbook is opened from Explorer
 

Would
ThisWorkbook.Path
do the job?

Alex J

"Brian Walters" wrote in message
...
I would like to be able to capture the directory that a
workbook is opened from Windows Explorer in a VB auto_open
macro. The CurDir function only works if the file was
opened using Excel.