Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The remote procedure call failed. (Exception from HRESULT: 0x80070 | Excel Worksheet Functions | |||
How to call a sub from UserForm Module | Excel Programming | |||
Call a Module | Excel Programming | |||
Call other sub in the same module | Excel Programming | |||
remote module | Excel Programming |