Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not undesratnd the error when calling EXcel macro from .vbs script
I have following Visual BAsic (.vbs) code:
wscript.echo "begin" set myExcel = CreateObject("Excel.Application") wscript.echo "before personal" set myWorkbook = myExcel.Workbooks.Open("C:\Documents and Settings\pmehrotr\Desktop\Local Files\PREM\oraclemonitorlogs\2012\MONITOR.XLSB") wscript.echo "before macro" myWorkbook.Run "'MONITOR.XLSB'!kdcallusers" myEXcel.quit ----------------- When I run it, it errors at myWorkbook.Run. macro kdcallusers is present in the MONITOR.XLSB file, so I don't know why the error occurs: begin before personal before macro C:\Documents and Settings\pmehrotr\Desktop\Local Files\PREM\oraclemonitorlogs\20 12\applymacros.vbs(7, 1) Microsoft VBScript runtime error: Object doesn't suppor t this property or method: 'myWorkbook.Run' |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Refresh Error when calling Excel Macro from VB.NET program | Excel Discussion (Misc queries) | |||
Calling a python script from VBA? | Excel Programming | |||
Calling excel-macros from script? | Excel Programming | |||
Calling a macro from ActiveX Script. | Excel Programming | |||
Macro script error - pls help !! | Excel Discussion (Misc queries) |