; 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: $$
-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
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
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
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
>
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