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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrong current directory 3
Excel is removing Macros from workbook 3
Saving Files 2
Excel 2013 menubar incompatibility? 1
with a macro open a workbook without the Auto_Open running 3
vba browse button set to current directory 2
Opening a workbook opens two 4
Copy cell value from one worksheet to matching worksheet in another workbook 4

Back
Top