Problem calling a procedure in another project

[Bill W]

Can anyone offer assistance with the reason the following does not
work:

' Procedure in TestWorkbook.xls
Sub UpdateStatus()
thePage = "Status"
theCols = Array(12, 20, 35, 20, 20, 20, 20, 3)
[MyMacros.xls].[ModuleName].UpdateSiteFolder
End Sub

I get the object required error. BTW - this macro needs to be in
TestWorkbook.xls and UpdateSiteFolder will always be in MyMacros.xls

Thanks!
Bill

 

[J Laroche]

Bill W wrote on 2005/03/22 14:20:

Can anyone offer assistance with the reason the following does not
work:

' Procedure in TestWorkbook.xls
Sub UpdateStatus()
thePage = "Status"
theCols = Array(12, 20, 35, 20, 20, 20, 20, 3)
[MyMacros.xls].[ModuleName].UpdateSiteFolder
End Sub

I get the object required error. BTW - this macro needs to be in
TestWorkbook.xls and UpdateSiteFolder will always be in MyMacros.xls

Thanks!
Bill

Maybe you should look at the statement DECLARE in help. DECLARE tells VBA
where to find your external procedures.

JL
Mac OS X 10.3.8, Office v.X 10.1.6

 

[Bob Greenblatt]

Can anyone offer assistance with the reason the following does not
work:

' Procedure in TestWorkbook.xls
Sub UpdateStatus()
thePage = "Status"
theCols = Array(12, 20, 35, 20, 20, 20, 20, 3)
[MyMacros.xls].[ModuleName].UpdateSiteFolder
End Sub

I get the object required error. BTW - this macro needs to be in
TestWorkbook.xls and UpdateSiteFolder will always be in MyMacros.xls

Thanks!
Bill

Have you established a reference to mymacros.xls from testworkbook.xls?

 

[Bill W]

thank you, the referencing worked. the mymacros.xls file has 700KB of
modules & forms simply because I couldn't get procedures in separate
workbooks to work together. I can finally begin to break-them up.