IP2017 > Load LOVs with Excel (Workspace issue)
edited Aug 8, 2018 2:24AM in Siebel Developers: UX, Web Tools, Scripting, Integration (MOSC) 3 commentsAnswered
Hi Everybody,
As many projects, we use an excel file to load initial administration data in the application (lov, views, resp,..)
This file uses vbscript to connect to the siebel app through the siebel tools/webclient dll.
Everything is still doing OK with IP2017 except for LOV...
Indeed, in IP17, LOVs are part of workspaces... Anyone knows how could i open a specific workspace from the excel vba ? Or maybe u have another technique to suggest to load LOVs (except typing )
[...]
Set SiebelApplication = CreateObject("SiebelDataControl.SiebelDataControl.1")
SiebelApplication.Login Connect, Admin.Range("D12").Value, Admin.Range("D13").Value
errCode = SiebelApplication.GetLastErrCode()
0