Accessing VBA subroutines in another workbook

  • Thread starter Thread starter marston.gould
  • Start date Start date
M

marston.gould

Is it possible to invoke
subroutines in another workbook if those
subroutines are not private?
 
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 >
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call routines of other workbooks? 1
Run subroutines in other workbooks? 4
temporarily disabling subroutines 1
Call Subroutine in Excel 3
List of Subroutines/functions in a workbook 1
Help with Calling a subroutine in the ThisWorkbook Class 6
Calling subroutine defined in another workbook (autostart workbook) 5
When something in module is shown as a macro 3

Back
Top