Hi all,

I have just finished creating 3 macros for one team in my company i.e
.xls files. For me to run these macros i have to firstly open 3 ra
data files (backlog, closed and opened cases). Then i have to open th
three macro files (Team1BacklogMacro, Team1ClosedMacro an
Team1OpenMacro). Then i have to go to each raw data file , run th
correct Macro, then save it under Team1BacklogCases, Team1....etc. As
will have to do this process with 4 teams, i would like to know i
there is a way of making this automatic, i.e. have a master macro tha
will ask for the file location of the raw data and the macro files
then run them all and then prompt for what each file will be saved as


Is there any one out there that could please help?
Any ideas on this would be great.

Thanks in advance,
Catha

--
Message posted from http://www.ExcelForum.com