The INFO("directory") function displays the incorrect directory.

T

TimR

The INFO("directory") function displays the default directory instead of the
directory that the work book is saved in. I have succeeded in getting the
function to report the correct directory if a "Save As" command is used, but
closing the workbook and excel and then reopening excel and the workbook
agains shows the results as the default directory instead of the directory
that the workbook is saved in.
 
R

Robert Flanagan

Use Path. For example,

ActiveWorkbook.Path

returns the path of the active workbook.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

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

Top