Initiate a macro in one workbook and have it run in 4 other workbooks

[Delta]

Hello,

I have a file that is updated every day from an extract out of a database system. There are four reports that are saved as separate excel files in a folder and another file for reporting purposes. The reporting file it set up with fomulas like ='[filename1 - variable.xlsm]Sheet1'!B7 and so on. I only want this file to update when someone tells it to. Currently I have auto calculation turned off and just force it to calculate when I need it to update. Then delete the data in the update files, save and close. When I extact the update information from the database system it automatically pastes the data into the one of the four files that are then utilized to update the reporting file. So, I am looking for a macro that will let me force the calculations in the reporting file then delete the data from a range of cells(i.e. A1:A:1000) in each update file then save and close. Is this possible and can anyone help?

Regards,

Delta

[xladept]

Maybe if you put:

Please Login or Register  to view this content.

in your routine???

[Norie]

Calculation of a worksheet can be forced like this.

Please Login or Register  to view this content.