| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command line used for opening .xls files and clicking abutton/running a function.
Ok, I finally found something I can work with:
Option Explicit On Error Resume Next ExcelMacroExample Sub ExcelMacroExample() Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open("C:\MyWorkbook.xls", 0, True) xlApp.Run "MyMacro" xlApp.Quit Set xlBook = Nothing Set xlApp = Nothing End Sub ..vbs script which can be used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Opening related files by clicking file address | Excel Discussion (Misc queries) | |||
| Opening files by double clicking takes for ever - Word, Excel | Setting up and Configuration of Excel | |||
| Running Macros from Command line | Excel Programming | |||
| Running a macro from a command line | Excel Programming | |||
| Running a macro from the command line | Excel Programming | |||
Hybrid Mode
