Capturing the directory when a workbook is opened from Explorer

  • Thread starter Thread starter Brian Walters
  • Start date Start date
B

Brian Walters

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.
 
Back
Top