Calling Subs in other WB
Hi,
Try it this way:
Application.Run "'FAMOUS Intermediate.xls'!LinksToValues_All"
--
Hope that helps.
Vergel Adriano
"san-avsc" wrote:
I'm trying to have a macro run a sub in another workbook, but I keep getting
an error. I use:
Application.Run "FAMOUS Intermediate.xls!LinksToValues_All"
but it tells me it can't be found. The wb is open and there are no typos.
|