$$Excel-Macros$$ Re: Splitting a text file

Of *Dilip Pandey *Sent:* Sunday, September 20, 2009 10:58 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Splitting a text file Hi Saurabh, Solution is attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan

$$Excel-Macros$$ Re: Splitting a text file

, 2009 10:58 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Splitting a text file Hi Saurabh, Solution is attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi

$$Excel-Macros$$ Re: Splitting a text file

Yes you can. (Note:  Excel 2007 allows over 1,000,000 rows) You can use something like:     Option Explicit Public Const ForReading = 1, ForWriting = 2, ForAppending = 3 Sub Readfile()     Dim fso, f, DataFileName, SheetName, Str, Srow     Dim cnt, ShtNo, CurrentSheet, RowsPerSheet