Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remote module call
I have 2 open workbooks Able and Baker
In WorkBook Able I call a Userform which has a ListBox. The ControlSource for the ListBox is a range located on WorkBook Baker. The ListBox shows a list of employees and their department. I want a sort button on my UserForm which will run a sort routine on the workbook Baker which has the employee data. I have the Sort routines defined on WorkBook Baker : Module1.SortByName Module1.SortByDepartment But how do I run the sort module on WorkBook Baker without leaving WorkBook Able? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remote module call
Patrick Simonds wrote:
I have 2 open workbooks Able and Baker In WorkBook Able I call a Userform which has a ListBox. The ControlSource for the ListBox is a range located on WorkBook Baker. The ListBox shows a list of employees and their department. I want a sort button on my UserForm which will run a sort routine on the workbook Baker which has the employee data. I have the Sort routines defined on WorkBook Baker : Module1.SortByName Module1.SortByDepartment But how do I run the sort module on WorkBook Baker without leaving WorkBook Able? Application.Run "'Baker'!SortByName" or if you have parameters Application.Run "'Baker'!SortByName", Parameter1, Parameter2,.. Workbook Baker shouldbe open. -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remote module call
Application.Run "Baker.xls!SortByName"
-- Regards, Tom Ogilvy "Patrick Simonds" wrote in message ... I have 2 open workbooks Able and Baker In WorkBook Able I call a Userform which has a ListBox. The ControlSource for the ListBox is a range located on WorkBook Baker. The ListBox shows a list of employees and their department. I want a sort button on my UserForm which will run a sort routine on the workbook Baker which has the employee data. I have the Sort routines defined on WorkBook Baker : Module1.SortByName Module1.SortByDepartment But how do I run the sort module on WorkBook Baker without leaving WorkBook Able? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The remote procedure call failed. (Exception from HRESULT: 0x80070 | Excel Worksheet Functions | |||
Remote module call | Excel Programming | |||
Call a Module | Excel Programming | |||
Call other sub in the same module | Excel Programming | |||
remote module | Excel Programming |