Re: $$Excel-Macros$$ Import data from notepad to excel

2011-08-11 Thread Venkat CV
; Select your text file > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Raghavendra > Sent: Wednesday, August 10, 2011 11:39 PM > To: MS EXCEL AND VBA MACROS > Cc: raghavendra....@gmail.com > Subject: $$

RE: $$Excel-Macros$$ Import data from notepad to excel

2011-08-11 Thread Rajan_Verma
-Macros$$ Import data from notepad to excel Hi, I have data (numbers) in note pad, Around 1,000,000 line items. Can I write a VBA code to copy data from Note pad to Excel? If yes, can anyone advise me with Code? Thanks and Regards, Raghavendra

Re: $$Excel-Macros$$ Import data from notepad to excel

2011-08-10 Thread XLS S
Great and very easy Option James On Wed, Aug 10, 2011 at 11:46 PM, ja...@macstop.co.uk wrote: > what happens if you just rename the .txt file to .csv and open in Excel... > > -- > -- > Some important links for excel

Re: $$Excel-Macros$$ Import data from notepad to excel

2011-08-10 Thread ja...@macstop.co.uk
what happens if you just rename the .txt file to .csv and open in Excel... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Import data from notepad to excel

2011-08-10 Thread XLS S
Better option try press Ctrl + O then Select File type "All Files" then select ur notepad file... link http://www.cpearson.com/excel/ImpText.aspx On Wed, Aug 10, 2011 at 11:38 PM, Raghavendra wrote: > Hi, > > I have data (numbers) in note pad, Around 1,000,000 line items. Can I >

$$Excel-Macros$$ Import data from notepad to excel

2011-08-10 Thread Raghavendra
Hi, I have data (numbers) in note pad, Around 1,000,000 line items. Can I write a VBA code to copy data from Note pad to Excel? If yes, can anyone advise me with Code? Thanks and Regards, Raghavendra -- -- Some impo