Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open WorkBook & Run Macro
From code in one workbook I want to open another workbook and run a
procedure that is in it. I have this in the first workbook: Sub RunTracking() Dim cdir As String Dim wb As Workbook For Each wb In Workbooks If wb.name = "NCP Tracking.xls" Then MsgBox ("NCP Tracking.xls is already open.") Exit Sub End If Next wb cdir = ActiveWorkbook.Path Workbooks.Open cdir & "\NCP Tracking.xls" Application.Run ("RunUpdate") End Sub I also tried Application.Run ("NCP Tracking.xls!RunUpdate"), but still says "Can not find" What I gotta do? Mike F |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro in 2nd Open workbook | Excel Discussion (Misc queries) | |||
Run a macro when I open a workbook | Excel Discussion (Misc queries) | |||
How to Run Macro in open workbook/s | Excel Discussion (Misc queries) | |||
how can I run a macro when I open a workbook? | Excel Discussion (Misc queries) | |||
Macro to open another workbook | Excel Programming |