path name

[jmnekrkt]

how can I extract just the path of the currently opened excel file? If I open the file from recent list, and use curdir, I receive excel default directory instead of the folder where the file resides. I need to open additional files the will be in the same directory whereever the current file is located. Current file location will vary by user.

Thank you

 

[acron]

A workbook has a Path property (returns an empty string for an unsaved file).

ActiveWorkbook.Path should give you what you are looking for (or perhaps Thisworkbook.Path)

A.C.

 

[jmnekrkt]

Perfect!

Thank you