Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling subroutine defined in another workbook (autostart workbook)
Hi,
I have a subroutine defined in my auto start workbook, which is named MyMacros.xls: MyMacros.xls: Option Explicit Sub TestMsg() MsgBox "Test Message" End Sub I want to run this macro whenever the save event runs in another workbook, say temp.xls: Temp.xls: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.Run "MyMacros.xls!TestMsg" End Sub This doesn't work. I get the error message: The macro 'MyMacros.xls!TestMsg' cannot be found. I'm positive MyMacros.xls is open (even if the workbook is hidden). Alt-F11 shows MyMacros.xls is open and the TestMsg module is defined. How can I call the TestMsg sub-routine whenever I click Save in another workbook? Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Calling A subroutine from a User Defined Function (UDF) that | Excel Programming | |||
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened | Excel Programming | |||
HELP! Calling subroutine in different workbook | Excel Programming | |||
How to check workbook is already opened before passing the workbook obj to a subroutine in Word | Excel Programming | |||
Calling a Public Subroutine in a Different Workbook | Excel Programming |