How can I read an Excel 2010 XLSX file in Siebel 8.1 using VBSCRIPT - or is there another way?
Please can someone help.
How can I read an Excel 2010 XLSX file in Siebel 8.1 using VBSCRIPT - or is there another way?
I have tried a couple of methods found by search the web but no luck. However, the articles I found referenced Excel 2003 file whereas I need to read 2010 files.
Below are just code snippets but they show the intended method of trying to open the xlsx file in each case…
Method 1:
Dim excel As Object
Set excel = CreateObject("Excel.Application")
excel.Application.DisplayAlerts = False
excel.Workbooks.Open "E:\\siebfile\\ztest.xlsx"
excel.Visible = False
...
...
Returns:
Object creation failed - bad object class(SBL-SCR-00156)