Import text file without specifying a path macro won't work
Does it ned to open as a database?
The "Connection:=fName" bit is trying to connect
to a database, which a text file is not.
Do you just need to open the file if so try,
Workbooks.OpenText Filename:=fileToOpen...) There are some
more fields you can fill in here, but that is the basics.
|