if Test Book.xls is open then

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

Worked for me.


--
Regards,
Tom Ogilvy


"DejaVu" wrote in
message ...

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