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

2009-09-28 Thread Dilip Pandey
macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf 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, > > > &

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

2009-09-27 Thread Ramkrishna Padhi
ear.” - Swami Vivekanand*** >> -- >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey >> *Sent:* Sunday, September 20, 2009 10:58 AM >> *To:* excel-macros@googlegroups.com >

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

2009-09-25 Thread Dilip Pandey
-- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf 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 Saura

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

2009-09-19 Thread Dilip Pandey
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 - 110062 On 9/18/09, Saurabh wrote: > > Hi All, > > > > I am importing a text file into excel where there is more data

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

2009-09-18 Thread Paul Schreiner
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     CurrentShee