Remote module call
 

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)

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)