Dear Prasad, Microsoft has already given a solution for this. Attaching the two links that will help you. It also has the macro to be written.
http://support.microsoft.com/kb/190032 http://support.microsoft.com/kb/120596 Please let me know if you need further help on this. Regards, Andy On Sun, Jul 26, 2009 at 9:50 PM, Prasad Gadgil <maocca1...@gmail.com> wrote: > *Dear All,* > > Currently all excel users are facing problem to import TXT / CSV data into > excel where the data size is more than 65536 rows. > > The problem is that due to limitation of 65536 rows, user is unable to > import the data into excel or he has to copy paste manually, which is much > difficult where data size is more than 2 lakhs. > > Now, if any expert share an micro where data will copy in different sheets > automatically, this will really help all excel users those are involve in > data handling. > > *Thanks & Regards > Prasad Gadgil* > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
