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'