Hi all...

I need to open files from folders x, y or z. When the file dialog opens it
either displayes the default path or the last used.

So how can I set the file dialog box to open from the desired folder.

Thanks
M.

Well that proved to be easily done by ChDir.

Sorry...

M.



"Mart" wrote:

Hi all...

I need to open files from folders x, y or z. When the file dialog opens it
either displayes the default path or the last used.

So how can I set the file dialog box to open from the desired folder.

Thanks
M.

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