View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChrisWalker ChrisWalker is offline
external usenet poster
 
Posts: 1
Default HELP! Calling subroutine in different workbook


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