HELP! Calling subroutine in different workbook

[ChrisWalker]

Hi
I am trying to call a subroutine test() which resides in Module1 of a
loaded add-in 'test.xla'.

I am calling it from a module in my current workbook, but I cannot get
it to run - instead I keep getting

Run time error 424 Object Required

I would be enormously grateful for any help!!

Chris

The code is:

IN MY CURRENT WORKBOOK:

-Sub testnow()
[test.xls].[Module1].test
End Sub-

IN MODULE1 OF TEST.XLA:

-Sub test()
MsgBox "test successful"
End Sub-

 

[Norman Jones]

Hi Chris,

Try:

Application.Run "'Test.xla'!Test"


---
Regards,
Norman



"ChrisWalker" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

Application.Run "'test.xla'!test"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ChrisWalker" <[email protected]>
wrote in message
news:[email protected]...

 

[ChrisWalker]

Thanks guys, works a treat.