Please Help me Out Guys !!

[newkid]

Hi Guys,
I am converting Excel File to Text File and I have to
Read Each Excel Page and then Convert it into Text File. I am able to
do that with help of using WorkBooks.Count.
And I am Searching Each Cell by Cell and then Writing it to
the Text File Using Sequencial File Method.
My Question is, 1. is there any other simple Method so that i
can do that job without running the bigger loop and is there any method
to find the last row with data in a Sheet.

2. And in Blacnk Excel Sheet i am Opening the Excel Sheet with Data
using Excel Instance using Macros. and when i close the Excel File and
open Again Blank Excel file is shown with the data.
Is there any way to clear the Contest every time i open Blank Excel
Sheet with Macros ?


Any of your suggetions will be greatly appreciated.

thanks
New Kid

 

[Bernard V Liengme]

Could you not use File | Save As and specify TXT type for each sheet?
Worked for me when I did it manually.
Bernard