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.

Hi

You need to use the combination of following

1. Dir function- to loop through directory and search files

2. Worksheets.Add After:=ActiveSheet

to create a new sheet

3. Application.InputBox or a Userform with Date Control to select the date

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)