View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Remote module call

Application.Run "Workbook2.xls!Sort"

Depends on how the macro is written.

If you qualify all your references, then there is probably no reason to
activate workbook2. If you use select and activate, then you would.

--
Regards,
Tom Ogilvy


"Patrick Simonds" wrote in message
...
Can you call a module from another Workbook (which is open)?

Lets say I have a module in workbook1 and I want to call a module called
Sort in workbook2. The Sort module would perform it's function in

workbook2
(ideally in the background without actually switching to workbook2)