I am trying to automate a macro and am using vbscript. The macro uses an add-in in excel. How to use VBscript to open excel with macro's enabled?
This is code I am using. Everything works -- except add-ins are disabled.
Dim oExcel
Dim oWorkBook
Set oExcel = WScript.CreateObject("Excel.Application")
oExcel.Visible = True
oExcel.DisplayAlerts = False
Set oWorkBook = oExcel.Workbooks.Open("File.xslm")
Thanks.
This is code I am using. Everything works -- except add-ins are disabled.
Dim oExcel
Dim oWorkBook
Set oExcel = WScript.CreateObject("Excel.Application")
oExcel.Visible = True
oExcel.DisplayAlerts = False
Set oWorkBook = oExcel.Workbooks.Open("File.xslm")
Thanks.