Call subroutine from another workbook

Is it possible to call a subroutine from another workbook?

I have a subroutine called TestSub in my "Test Book.xls" workbook. I open this book, then try to call subroutine (TestSub) in that book.

Please Login or Register  to view this content.

Is this even possible?

TIA,
DejaVu

if Test Book.xls is open then

Sub RunTestsub()
Application.Run "'Test Book.xls'!TestSub"
End Sub

Worked for me.


--
Regards,
Tom Ogilvy


"DejaVu" <[email protected]> wrote in
message news:[email protected]...
>
> Is it possible to call a subroutine from another workbook?
>
> I have a subroutine called TestSub in my "*Test Book.xls*" workbook. I
> open this book, then try to call subroutine (-TestSub-) in that book.
>
> Code:
> --------------------
> If frmDate.chkATime Then
> Set wb = Workbooks("Test Book.xls")
> If wb = Nothing Then
> Workbooks.Open "C:\Test Folder\Test Book.xls", False, True
> End If
> Call TestSub
> Workbooks("Test Book.xls").Close False
> End If
> --------------------
>
>
> Is this even possible?
>
> TIA,
> DejaVu
>
>
> --
> DejaVu
> ------------------------------------------------------------------------
> DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
> View this thread: http://www.excelforum.com/showthread...hreadid=481877
>

Thanks Tom - That was exactly what I was looking for. I just couldnt find the right syntax for it.

DejaVu