Hi Jat,

Can you open the file manually in Excel? If not, what type of file extension
does it have; is it .txt? If you cannot see the file extension then open
Control Panel - Folder Options - View tab and uncheck 'Hide extensions for
known file types'.

If it is not .txt then copy the file to a new filename and then rename it to
..txt (Ignore the warnings about renaming) and try to open the new file with
Excel again and if that works test the code again with the renamed file.

If code is still not working, record a macro to open it and compare the
recorded code with the code you posted. If you still can't sort it out then
post the recorded code so that I (or someone else) can compare it.

--
Regards,

OssieMac