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' |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not undesratnd the error when calling EXcel macro from .vbs script
Replace myWorkbook.Run with myExcel.Run
-- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (free and commercial excel programs) wrote in message news:5600740.2597.1333854012527.JavaMail.geo-discussion-forums@vbvi18... 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' |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not undesratnd the error when calling EXcel macro from .vbs script
On Sunday, April 8, 2012 12:07:08 AM UTC-4, Jim Cone wrote:
Replace myWorkbook.Run with myExcel.Run -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (free and commercial excel programs) wrote in message news:5600740.2597.1333854012527.JavaMail.geo-discussion-forums@vbvi18... 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' Jim: Thanks a lot, that was it. I do not know why many examples on internet were using Run with Workbook instead of Excel. Prem |
Reply |
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) |