Dear friends,

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

Thanks,
G

--
Message posted from http://www.ExcelForum.com

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
--
Regards,
Tom Ogilvy

"banavas " wrote in message
...
Dear friends,

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

Thanks,
G.


---
Message posted from http://www.ExcelForum.com/

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
--
Regards,
Tom Ogilvy


---
Message posted from http://www.ExcelForum.com/

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"banavas " wrote in message
...
Dear friends,

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

Thanks,
G.


---
Message posted from http://www.ExcelForum.com/