• 0

Excel Marcos Help


Question

Hey guys, so at work need to use excel a lot and i picked up on macros to speed up calculations and sorting that i do often, however the most time consuming part is when i input the data from .csv files ###### the same procedure for 20 - 30 files. I am hoping someone can tell me how to make a macro so that i can point to a folder and it will import all of the csv files into different sheets and rename the sheets to the file name? So basically if i have folder called logs with test1.csv and test2.csv i want the macro to import the data into sheet 1 and 2 of the workbook and rename the sheets to test1.csv and test2.csv or test1 and test2. I am using excel 2007.

Thanks

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.