Hi I am having a problem. I thought that thisworkbook.path would give m
the path of the current workbook.
If I set a= thisworkbook.path
a =""
I dont understand what I changed. I use to set the DefaultFilePath t
nothing.
Now I am trying to distribute the file and I need to set the curdir t
the dirertory of the open workbook. I can navigate from there but
cant seem to do this even if I set DefaultFilePath to "" Since th
workbook is already open.
Rod Taylo

--
rjtaylo
-----------------------------------------------------------------------
rjtaylor's Profile: http://www.excelforum.com/member.php...nfo&userid=590
View this thread: http://www.excelforum.com/showthread.php?threadid=26595

Thisworkbook.path will give the path for the workbook containing the code--and
that's not always the activeworkbook.

Activeworkbook.path will give the path for the active workbook--not always the
one with the code.

The only time I've seen the .path return "" is if the workbook hasn't been ever
saved--it's been created File|New (or the equivalent in code).

rjtaylor wrote:

Hi I am having a problem. I thought that thisworkbook.path would give me
the path of the current workbook.
If I set a= thisworkbook.path
a =""
I dont understand what I changed. I use to set the DefaultFilePath to
nothing.
Now I am trying to distribute the file and I need to set the curdir to
the dirertory of the open workbook. I can navigate from there but I
cant seem to do this even if I set DefaultFilePath to "" Since the
workbook is already open.
Rod Taylor

--
rjtaylor
------------------------------------------------------------------------
rjtaylor's Profile: http://www.excelforum.com/member.php...fo&userid=5902
View this thread: http://www.excelforum.com/showthread...hreadid=265956

--

Dave Peterson

A workbook doesn't have a path until it has been saved.

Perhaps you are setting it before the workbook has been saved.

DefaultFilePath is only applicable when Excel starts up. You should need to
work with that attribute.

--
Regards,
Tom Ogilvy


"rjtaylor" wrote in message
...

Hi I am having a problem. I thought that thisworkbook.path would give me
the path of the current workbook.
If I set a= thisworkbook.path
a =""
I dont understand what I changed. I use to set the DefaultFilePath to
nothing.
Now I am trying to distribute the file and I need to set the curdir to
the dirertory of the open workbook. I can navigate from there but I
cant seem to do this even if I set DefaultFilePath to "" Since the
workbook is already open.
Rod Taylor


--
rjtaylor
------------------------------------------------------------------------
rjtaylor's Profile:
http://www.excelforum.com/member.php...fo&userid=5902
View this thread: http://www.excelforum.com/showthread...hreadid=265956

If the workbook has never been saved, it doesn't have a path. Could this be
the problem?


On Sun, 3 Oct 2004 19:23:30 -0500, rjtaylor
wrote:


Hi I am having a problem. I thought that thisworkbook.path would give me
the path of the current workbook.
If I set a= thisworkbook.path
a =""
I dont understand what I changed. I use to set the DefaultFilePath to
nothing.
Now I am trying to distribute the file and I need to set the curdir to
the dirertory of the open workbook. I can navigate from there but I
cant seem to do this even if I set DefaultFilePath to "" Since the
workbook is already open.
Rod Taylor