VBA Application.Run 1

[WaterSprite]

Windows(Format(Date, "mmmmyyyy") + "Daily_r5.xls").Activate
works just fine.
What I cannot figure out how to do is to use the code with an Appication.Run to run a macro.
I am assuming that what I need is similiar to:

Applcation.Run "'(Format(Date, "mmmmyyyy") + "Daily_r5.xls'!Macro14"

But that does not work.

 

[PHV]

Perhaps this ?

Application.Run "'" & Format(Date, "mmmmyyyy") & "Daily_r5.xls'!Macro14"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886