The following line opens the macro "Recalculate" in the file "Template.xls":
Application.Run "'Template.xls'!Recalculate"
The problem is the name of the file often changes. That change is recorded
in cell "C27" of worksheet "Customize". Can someone tell me the code to have
the line reference this cell? I've tried many variations of:
Application.Run "'" & Sheets("Customize").Range("C27").Value &
"'!Recalculate" with no luck. Thanks!