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