4 Replies Latest reply on Sep 26, 2013 8:40 PM by Celvin Kattookaran

    Open Smartview with vbscript


      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???