Importing Text File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I import a text file with Workbooks.OpenText so that it import the text file into an already existing worksheet? Everytime I use Workbooks.OpenText it opens a new worksheet from the text file. Help is appreciated in advance.
 
You can't. If you have Excel 2000 or later, go into Data=>Get External Data
and select import text file.

Turn on the macro recorder to get the code.

the alternative is to use opentext, then copy the data to your existing
file, close the text file without saving changes.

--
Regards,
Tom Ogilvy


Daniel Brow said:
How do I import a text file with Workbooks.OpenText so that it import the
Click to expand...
text file into an already existing worksheet? Everytime I use
Workbooks.OpenText it opens a new worksheet from the text file. Help is
appreciated in advance.
 
Back
Top