Call a sub from another a sub located in another workbook

Hi Everyone,

I would like to call a macro from Workbook 1 that is located in another workbook (let's call it workbook2)

I saw that I could use the following:

application.run Workbookname!SubName

however my workbook will have a different name everyday as it contains the date within its name. (ie workbook20140619, tomorrow it would be Workbook20140620)

Would you know how to do that ?

Thanks in advance for your help.

Thanks Paresh, let me try that.

Awesome that worked!