Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the suggestion - this more or less came from
"microsoft.public.scripting.vbscript" openexcel Sub openexcel() MsgBox "Start" Dim xlObj Set xlObj = CreateObject("excel.application") xlObj.Workbooks.Open "C:\Folder\FileName.xls" xlObj.Run "MacroName" xlObj.ActiveWorkbook.Saved = True xlObj.ActiveWindow.Close xlObj.Quit Set xlObj = Nothing MsgBox "End" End Sub -- "Trying to make reports so easy... even a monkey could run ''em!" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
How to launch one XLA from another on Excel launch | Excel Programming | |||
Want to launch Excel from C# app | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
Launch a Sub Worksheet_Change Event from inside a macro | Excel Programming |