Am I missing part of this thread? Or is this a new topic? If it's new... what you're asking is fairly simple. But I need more info.
Are the files in a single folder? What is the format of the name that you want to parse to get the third "word"? like: "file_For_Tommy.xls", "file For Tommy.txt", what delimits a "word"? Are you familiar with VBA? Have you started? I think I can throw something together quickly (10-15 minutes). Paul ________________________________ From: mmccaws2 <mmcc...@comcast.net> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Monday, June 1, 2009 4:34:57 PM Subject: $$Excel-Macros$$ importing multiple data files (csv) 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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
