Where was my excel program started from?

**CaptMac** · 10-20-2008, 07:41 PM

I start my excel program from a "Shortcut" in "Folder 1".
That shortcut points an Excel program in "Folder 2".

When Excel is started,
Parent.Path returns "Folder 2",
but I really need to know what "Folder 1" was.

It seems that should be available as
when I do "Save File As"
it is pointing to "Folder 1".
Is there a way to find what "Folder 1" really was from the VBA enviornment.

Thanks for the help,
Mac

**davesexcel** · 10-20-2008, 09:50 PM

Not understanding the question completely...
you can use a formula to get the file path of a saved workbook.....
=CELL("filename",A1)
place it in a cell exactly how it is written.

**shg** · 10-20-2008, 10:50 PM

I don't think you're going to find Folder 1 unless you can find something akin to a call stack in Windows API.

**CaptMac** · 10-22-2008, 02:01 PM

In Excel, when I open <File>, <Save As>
it points to "Folder 1".

Is there any way in VBA of accessing this information?

Mac

**dcgrove** · 10-22-2008, 02:52 PM

can you not go up a level in the directory structure in the save-as dialog box?

**CaptMac** · 10-22-2008, 04:27 PM

I'm not trying to "go up a level".

What I want to get in VBA is the path to directory that is displayed when I do <File>, <Save As>.

And this is not what is displayed in "Parent.Path".

Mac

**shg** · 10-22-2008, 08:57 PM

I start my excel program from a "Shortcut" in "Folder 1" that points an Excel program in "Folder 2". When Excel is started, Parent.Path returns "Folder 2", but I really need to know what "Folder 1" was.

It seems that should be available as when I do "Save File As" it is pointing to "Folder 1".

When you say 'Excel program', I'm assuming you mean a workbook.

When I do that, the default SaveAs path is "Folder 2".

**CaptMac** · 10-22-2008, 10:47 PM

Yes, I mean opening a workbook in Excel that I also execute VBA programs in.

Mac

**shg** · 10-23-2008, 12:12 AM

Right.

Well, as I said, the default saveas path for me is the directory the workbook is in, not the directory containing the shortcut from which it was opened.

**Leith Ross** · 10-23-2008, 06:05 PM

Hello CaptMac,

The shortcut only contains information about the Target, the file to be opened. It contains the full path of file and an auxillary folder path for files the program may require. It does not contain any information about its own location. It is not possible to back track from the program to the shortcut using either VBA or the API.

Sincerely,
Leith Ross