Hi Anil, Do you mean to say, you want 40000 text files... And what do you mean by specified delimiter...
I can give you the code which wil seprate the rows in any number of files but the file name would be same as file01, file02 file03 and so on.... Please lemme know...if it's okay... On Wed, Mar 25, 2009 at 5:57 PM, Anil Patel <[email protected]> wrote: > Hiii... > > > Guys I have a worksheet with around 40000 rows.. And I need a VBA code to > Export Each Row in a separate Text file, with specified delimiter . . > > And all the files should be exported in a particular folder, Named on any > of particular cell in the row... > > Thanks in advance. > > Regards. > Anil. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
