Please Help me Out Guys !!

  • Thread starter Thread starter newkid
  • Start date Start date
N

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
 
Could you not use File | Save As and specify TXT type for each sheet?
Worked for me when I did it manually.
Bernard
 
Back
Top