Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

How can I read an Excel 2010 XLSX file in Siebel 8.1 using VBSCRIPT - or is there another way?

edited Apr 29, 2017 5:00AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 1 commentAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center