opentext

[banavas]

Dear friends,

I want read data from two txt files and import them in one workbook bu
in different sheets. Any ideas?

Thanks,
G

 

[Tom Ogilvy]

An easy approach
application.ScreenUpdating = False
Open the first, copy the data to the first worksheet, close without saving
changes
Repeat for the second.
application.ScreenUpdating = True

 

[Tom Ogilvy]

An easy approach
application.ScreenUpdating = False
Open the first, copy the data to the first worksheet, close without
saving
changes
Repeat for the second.
application.ScreenUpdating = True

 

[Earl Kiosterud]

G,

If you have Excel 2002, use Data - Import External Data - Import Data. You
can specify where to put the data in the workbook, and use Refresh later to
reread the text file.