Dear M

Try this :-

Make the desired directory the current directory using the followin
statement in your sub :-

curdir (path)
then use the getopenfilename method

This will show the path that you have set as the current directory a
the default folder.


Best regards


Deepa

--
agarwaldv
-----------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...fo&userid=1134
View this thread: http://www.excelforum.com/showthread.php?threadid=27007