Acessing Starting Folder Path

I start an Excel program from a shortcut in different folders. I know that I can find the path of the Excel program in "Parent.Path". But I don't know how to find the path of the folder the shortcut was in. It should be findable because when I try to do something like <Save>, Excel knows the correct folder there.

An example: I open Excel in "Folder 1" using a shortcut to the Excel Program in "Folder 2". Parent.Path tells me "Folder 2". How do I find out what "Folder 1" is from inside Excel?

Thanks,

Mac in Berkeley, CA

Hello CaptMac,

Welocme to the Forum!

If I understand you correctly, you referring to a workbook and not the Excel application. The following code will return the full directory path for the workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks, Leith, for the response.

With regards to my original example

ThisWorkbook.Path yields the path to the folder the workbook is in: ie. /../Folder2.

What I'm looking for is something that yields the path to the folder the shortcut was in: ie. /../Folder 1.

Mac

Thanks, RoyUK, for the reply. But...

CurDir() gives me a pointer to my home directory, not to /../ Folder1
when I tried it in my code.

Mac

It turns out that what I thought might work does NOT.

The only reference to external files is the WorkBook.Parent. SO that's all one can find out.

Captn Mac