Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Perform task on multiple sheets in a folder
Hi
I have multiple XLS files located in one folder. Each week I have to manually go into the files and then copy all the worksheets into my template. I then run a macro in the template and when done save the file as a name in the appropriate folder. I repeat this for all my spreadsheets. Is there a macro that can open all the spreadsheets in a particular folder one by one then copy and paste all the sheets into another spreadsheet which shall remain the same (it's a template), I would then like the macro to call the macro in my template sheet then save the spreadsheet in another location with the name of the spreadsheet being the value in Cell A1 of the sheet "Products". I really hope this makes sense to someone, Thanks for your help, Andrea |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Perform a task if result is a whole number | Excel Programming | |||
perform calculations in 2 sheets | Excel Worksheet Functions | |||
Perform code on all (closed) workbooks scattered across sub-folders of common parent folder | Excel Programming | |||
linking an excel document to my task folder in outlook | Excel Discussion (Misc queries) | |||
Using a macro to perform a TASK on another workbook | Excel Programming |