Hello,

I am looking for a way to find and store the absolutie startup path of a
workbook.
I have an Excel application that is loaded 'empty' and then saved in another
place when filled in.
I need to know the startup path of the workbook to maintain ini-files and
use relative paths.

Of course I tried to use Workbook.Path, but after saving the file this is
the path of the saved file, not the path where it was originally started
from!

What is the best way to handle this?

Ed van Wijngaarden

a blank workbook has no "path" until it is saved. The
blank workbook exists in memory only until it is saved and
when saved, the contents of the memory is moved to the
disk. now it has a path.
are you talking about the default save directory or the
directory where Excel.exe is?
but even so. excel.exe is loaded into memory which is
where the blank workbooks are created and they have no
path until they are saved, if they are saved.

-----Original Message-----
Hello,

I am looking for a way to find and store the absolutie
startup path of a
workbook.
I have an Excel application that is loaded 'empty' and
then saved in another
place when filled in.
I need to know the startup path of the workbook to
maintain ini-files and
use relative paths.

Of course I tried to use Workbook.Path, but after saving
the file this is
the path of the saved file, not the path where it was
originally started
from!

What is the best way to handle this?

Ed van Wijngaarden


.

Get the path before you do the save.

--
Regards,
Tom Ogilvy

"E.J. van Wijngaarden" wrote in message
...
Hello,

I am looking for a way to find and store the absolutie startup path of a
workbook.
I have an Excel application that is loaded 'empty' and then saved in
another
place when filled in.
I need to know the startup path of the workbook to maintain ini-files and
use relative paths.

Of course I tried to use Workbook.Path, but after saving the file this is
the path of the saved file, not the path where it was originally started
from!

What is the best way to handle this?

Ed van Wijngaarden