View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DejaVu[_55_] DejaVu[_55_] is offline
external usenet poster
 
Posts: 1
Default 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.
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 I
-------------------


Is this even possible?

TIA,
DejaV

--
DejaV
-----------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262
View this thread: http://www.excelforum.com/showthread.php?threadid=48187