I have over 100 excel files with different names used by upto 8 different people at different time. Each file has a macro which runs on open it collects all the data it requires and stores it in a1:f1 on sheet 10 and the on close runs another macro to collect the same data again and store it on a2:f2 , then the same macro copies the info from a1:f2 and pastes it in a file calles usage.xls
I also have another macro which is stored on my contol panel.xls which is call UpdateCSC, this opens each excel file (over 100) and then simply closes them, the purpose is to update my monitor as to what work is still to do.
the problem I have is when I run the update and the macro opens the excel files it also tries to run the workbook open & close macros. I want to be able to disable these when the update macro runs.
can this be done. I need code please I have spent too much time on this and need it to complete this project
Bookmarks