Call function from one workbook that resides in another workbook m

G

Guest

How can you call a function from one workbook to another

iTemp = workbooks(“Workbook1â€).module(“Module1â€).GetTotalRows

Thanks in advance,

Stewart Rogers
 
G

Guest

Tom,

Thanks for the reply. How would I pass a parameter? Want to try something
like this :

itemp = Application.Run("Workbook1.xls!Module1.GetTotalRows(1,2)") where i
am passing 2 integers

Thanks for your help
 
G

Guest

Tom,

Figured it out .. thanks for your help!!!


Datasort said:
Tom,

Thanks for the reply. How would I pass a parameter? Want to try something
like this :

itemp = Application.Run("Workbook1.xls!Module1.GetTotalRows(1,2)") where i
am passing 2 integers

Thanks for your help
Click to expand...
 

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

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Pulling data from one workbook to another one using VBA 0
non basic code in call stack 3
Call routines of other workbooks? 1
Reference code in another workbook from a calling workbook 1
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
User Defined Function being called by changes to an independent workbook 13
Replace Code Programmatically 3

Top