Problem calling a procedure in another project

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill W - 22 Mar 2005 20:20 GMT

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

Reply to this Message

J Laroche - 23 Mar 2005 01:09 GMT

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

> Can anyone offer assistance with the reason the following does not
> work:
[quoted text clipped - 11 lines]
> 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

Reply to this Message

Bob Greenblatt - 23 Mar 2005 14:25 GMT

On 3/22/05 2:20 PM, in article
1111519231.122302.142410@l41g2000cwc.googlegroups.com, "Bill W"
<billwarren@gmail.com> wrote:

> Can anyone offer assistance with the reason the following does not
> work:
[quoted text clipped - 11 lines]
> Thanks!
> Bill

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

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Bill W - 27 Mar 2005 23:11 GMT

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.

Reply to this Message

Mac Forum / Applications / Excel / March 2005

Problem calling a procedure in another project