opentext

B

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
 
T

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
 
T

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
 
E

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.
 
Top