Call function from one workbook that resides in another workbook m
 

How can you call a function from one workbook to another

iTemp = workbooks(€œWorkbook1€�).module(€œModule1€�).G etTotalRows

Thanks in advance,

Stewart Rogers

Call function from one workbook that resides in another workbook m
 

itemp = Application.Run("Workbook1.xls!Module1.GetTotalRow s")

--
Regards,
Tom Ogilvy

"Datasort" wrote in message
...
How can you call a function from one workbook to another

iTemp = workbooks("Workbook1").module("Module1").GetTotalR ows

Thanks in advance,

Stewart Rogers

Call function from one workbook that resides in another workbo
 

Tom,

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

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

Thanks for your help




"Tom Ogilvy" wrote:

itemp = Application.Run("Workbook1.xls!Module1.GetTotalRow s")

--
Regards,
Tom Ogilvy

"Datasort" wrote in message
...
How can you call a function from one workbook to another

iTemp = workbooks("Workbook1").module("Module1").GetTotalR ows

Thanks in advance,

Stewart Rogers

Call function from one workbook that resides in another workbo
 

Tom,

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


"Datasort" wrote:

Tom,

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

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

Thanks for your help




"Tom Ogilvy" wrote:

itemp = Application.Run("Workbook1.xls!Module1.GetTotalRow s")

--
Regards,
Tom Ogilvy

"Datasort" wrote in message
...
How can you call a function from one workbook to another

iTemp = workbooks("Workbook1").module("Module1").GetTotalR ows

Thanks in advance,

Stewart Rogers