Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Text File
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Text File
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 wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Importing a text file | Excel Discussion (Misc queries) | |||
Importing Text File | Excel Discussion (Misc queries) | |||
Importing text file | Excel Discussion (Misc queries) |