4 Replies Latest reply: Sep 26, 2013 3:40 PM by Celvin Kattookaran RSS

    Open Smartview with vbscript

    991305

      Hi all,

       

      I am trying to write a vbscript which opens smartview and executes two macros....

       

      After I execute the script, Excel opens, the smartview ribbon is not visible and I get the following error message:

       

      The Object does not support this property or method: 'xl.Application.run'

       

      This is the vbscript:

       

      Set xl = CreateObject("Excel.application")
      xl.Application.Workbooks.Open "path+sheetname.xlsm"
      xl.Application.Visible = true
      xl.Application.run = "'workbookname.xlsm'!Tabelle1.ConnectTraining"
      xl.Application.run = "'workbookname.xlsm'!Tabelle1.DisconnectTraining"
      'ActiveWorkbook.Close False

       

      Any Ideas???