View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
new guy new guy is offline
external usenet poster
 
Posts: 1
Default 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.