Hello Dear, Here is the attached macro for your problem. Here string are picked after tab or new line. u can make change if string are separated by any special character.
Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: > Hello Dear, > This problem is alredy discussed in previous post. > try to find out importing txt from notepad to excel. > > > > > > > > > > > > > Hope it Will Help > Happy to Help > :) > Shyam > > On Mon, Apr 5, 2010 at 2:37 PM, Mahesh <mahender.bi...@gmail.com> wrote: >> Dear All, >> >> Need ur advise... >> >> I got around 20 text files in a day,which had 13 to 15 columns separated by >> "|" this sign. each file contains around 15 lacs or more line items. >> >> when i import that text file in excel 2007, it takes the first 10 lacs >> records; rest does not come. >> >> Need ur help to solve this, >> >> I want that rest records should move to next sheet of the same workbook >> >> -- >> With Love, >> Mahesh Bisht >> >> -- >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > > Thanks Regards > Shyam > Software Engineer > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > When one door of happiness closes, another opens; > but often we look so long at the closed door that we do not see the > one which has been opened for us. > - Helen Keller > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, > aber oft schauen wir so lange auf die geschlossene Tür, > dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
Importing txt to Excel.rar
Description: Binary data
