Re: $$Excel-Macros$$ Import Data into excel from notepad

2010-06-11 Thread Intelligent But Crazy
Hi Ashish, Thanks for the Help, It's really too helpfull for me, But could you give just one more favour, I Imported the data on Excel N data comes in N numbers of sheet, now I want to "Text to Colunm" of First colunm (A:A) of every sheet so what the changes I have to do in that macro.

Re: $$Excel-Macros$$ Import Data into excel from notepad

2010-06-10 Thread ashish koul
run it select the notepad file and click on ok On Thu, Jun 10, 2010 at 9:59 AM, Mahesh wrote: > Hi Ashish, > > Thank for the codes but i m not able to use them, > > Can u give my the process how to start and how to end the same. > > > > On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote: > >>

Re: $$Excel-Macros$$ Import Data into excel from notepad

2010-06-09 Thread Mahesh
Hi Ashish, Thank for the codes but i m not able to use them, Can u give my the process how to start and how to end the same. On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote: > ub importnotepaddata() > On Error GoTo xdd > > Dim FileName As String > FileName = Application.GetOpenFilename("Te

RE: $$Excel-Macros$$ Import Data into excel from notepad

2010-06-08 Thread Prashant
To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Import Data into excel from notepad Dear All, Need your help on below mention issue. I have a notepad file which contains more than 10 lacs records. Can anyone give me a solution, how to open it in excel? -- With Love, Ma

$$Excel-Macros$$ Import Data into excel from notepad

2010-06-08 Thread Mahesh
Dear All, Need your help on below mention issue. I have a notepad file which contains more than 10 lacs records. Can anyone give me a solution, how to open it in excel? -- With Love, Mahesh Bisht -- -- Some impor