HI,

You have to change the ndrive as well before changing the folder.

Regards
JY

"massoud" wrote in
message ...

Hi there.
I want to open text files with vba in excel. As long as the file is in
the My Documents folder, I have no problem. When the file is in another
folder and another drive, and I have to give the path of the file, I use
the chdir() function. However this doesn't work. ( actaually sometimes
it does and sometimes it doesn't) .

Thanks for the advise.


--
massoud
------------------------------------------------------------------------
massoud's Profile:
http://www.excelforum.com/member.php...o&userid=29031
View this thread: http://www.excelforum.com/showthread...hreadid=487584