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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open WorkBook & Run Macro
Mike,
it is the embedded spaces I think. Try Application.Run ("'NCP Tracking.xls'!RunUpdate") -- HTH RP (remove nothere from the email address if mailing direct) "Mike Fogleman" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open WorkBook & Run Macro
Thanks Bob, that was it. Silly me tried to use the Help example for the Run
Method which says: mySum = Application.Run("MYCUSTOM.XLM!My_Func_Sum", 1, 5) MsgBox "Macro result: " & mySumNo single quotes in that is there?Mike F"Bob Phillips" wrote in message ... Mike, it is the embedded spaces I think. Try Application.Run ("'NCP Tracking.xls'!RunUpdate") -- HTH RP (remove nothere from the email address if mailing direct) "Mike Fogleman" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open WorkBook & Run Macro
That's the main problem with help that I find, it always gives a basic
example, usually one that you can work out yourself, and never shows you how to really push it. -- HTH RP (remove nothere from the email address if mailing direct) "Mike Fogleman" wrote in message ... Thanks Bob, that was it. Silly me tried to use the Help example for the Run Method which says: mySum = Application.Run("MYCUSTOM.XLM!My_Func_Sum", 1, 5) MsgBox "Macro result: " & mySumNo single quotes in that is there?Mike F"Bob Phillips" wrote in message ... Mike, it is the embedded spaces I think. Try Application.Run ("'NCP Tracking.xls'!RunUpdate") -- HTH RP (remove nothere from the email address if mailing direct) "Mike Fogleman" wrote in message ... 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 |
Reply |
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 |