Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Macro Files
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Files - Think Outside the Box | Excel Discussion (Misc queries) | |||
Combining Two Files | Excel Worksheet Functions | |||
combining files | New Users to Excel | |||
Macro Help- combining "CS" files | Excel Discussion (Misc queries) | |||
Combining Files | Excel Programming |