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]...
>
> 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-
>
>
> --
> ChrisWalker
> ------------------------------------------------------------------------
> ChrisWalker's Profile:
> http://www.excelforum.com/member.php...o&userid=32022
> View this thread: http://www.excelforum.com/showthread...hreadid=517739
>

[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]...
>
> 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-
>
>
> --
> ChrisWalker
> ------------------------------------------------------------------------
> ChrisWalker's Profile:
http://www.excelforum.com/member.php...o&userid=32022
> View this thread: http://www.excelforum.com/showthread...hreadid=517739
>

[ChrisWalker]

Thanks guys, works a treat.