Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing VBA subroutines in another workbook
Is it possible to invoke
subroutines in another workbook if those subroutines are not private? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing VBA subroutines in another workbook
The called workbook (or addin) must be open. (if it's referenced it will be opened automatically) IF it's NOT referenced: Run "MyFunctions.xla!sayhi" Dim v v = Run("MyFunctions.xla!doublethis", Range("a1")) If you added a reference to that workbook in Tools/References then you'd call it like any other procedure in the workbook. (Note you have to rename the Project in the referenced workbook so it wont conflict with the "calling" workbook's project name. Assume the project in MyFunctions.xls is named prjFunctions SayHi of prjFunction.SayHi keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool " wrote: Is it possible to invoke subroutines in another workbook if those subroutines are not private? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing workbook info from a different workbook macro | Excel Programming | |||
Accessing workbook info from a different workbook macro | Excel Programming | |||
Accessing information from second workbook | Excel Programming | |||
Finding out if subroutines exist in another workbook | Excel Programming | |||
Accessing Closed Workbook | Excel Programming |