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