Macro to run when another workbook is saved

[NewExcelUser]

Good Day, fellow Exceller's.

I am facing a challenge I am uncertain can be addressed by Excel.

Is there a way for a macro to run, (we will call it "Test.xlsx"), when the workbook "Test2.xlsx" is saved?

So, when Test2.xlsx is saved, Test.xlsx says "Hey! Test2.xlsx has been updated! Time to run our macro!"

So basically I'm looking for a macro to run in one workbook, when another workbook has been saved.

Can this be accomplished with Excel? I have Googled for quite some time and am unable to find a solution to this.

Your time and energies are appreciated.

Regards,

NEU

[HaHoBe]

Hi, Neu,

you may get there by using class programming and either add the code to run in your personal macro workbook or in an AddIn to be active upon opening Excel in normal mode. Since you are not looking for a nomral macro to be started by macro but by event and you want the code to work for macro-free workbooks that should be the way go. You may start looking at Classes in VBA to get some information about what the subject may look like.

Sample for the code may look like this. Enter a new Class Module and name it XLEvents. Code for XLEvents:

Please Login or Register  to view this content.

In a stanard module:

Please Login or Register  to view this content.

Code for ThisWorkbook:

Please Login or Register  to view this content.

Ciao,
Holger