ok found it
http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=210201
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Thursday, November 8, 2012 1:34 PM
Subject: $$Excel-Macros$$ run macro from another fil
Hi All,
I'd like to ask you for help. I'd like to run macro from different file. So I
have master file where I have all data, this data a copied to another file and
after that macro need to be run. issue is: each day name of the file is
different so I can use stable one like
Application.Run
