Hi Mike,Check the article below http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html This helps in copying many small files into a single excel workbook and each file gets it's own sheet.
On Mon, Jun 1, 2009 at 1:34 PM, mmccaws2 <mmcc...@comcast.net> wrote: > > Hi > > Maybe I'm not using the right search terms, but I couldn't locate how > to import over 100 small files into Excel. Each file should get it's > own worksheet. And each worksheet should be name with the 3rd "word" > or character string in the file. In case someone is wondering, the > total number of files is less than 1MB. > > Thanks > > Mike > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
