View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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.