Reading in 29 Text files Each Month
My Excel 2010 question is two-fold. First I have 29 static tables that are generated each month. I have figured out how create individual macros (each table is a little different from the next) for each table to format it into a nice looking Excel sheet. The first part of my question is: Is there a way to combine all the Macros to run one after the other creating a new sheet for each of the imported tables and 2nd: Is there a way to prompt for month and year and use that dynamically within the macros for the change in month for processing? My file names look like TAY0112.rpt, TBY0112, TCY0112.rpt, TDM0112.rpt, TDY0112.rpt, etc. Any help on this would be greatly appreciated.