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'

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'

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