EXCEL | VBA

Marc_Belen24
edited 2:34AM in Eikon COM

we are moving to LSEG Workspace. I need to open a Workspace Excel with VBA. The workspace add-
in is inserted correctly via File --> Options and if you manually open an Excel, the workspace add-in is also included.

But if I call an Excel via VBA, unfortunately the workspace add-in is missing.

What must the VBA code be to open a Workspace Excel? Which libraries are needed if necessary?

This worked before, but it didn't work with LSEG Workspace.

SET XL = CreateObject("Excel.Application")

Set xlWbk = xl.workbooks.open(strFileName, 3, False)
XL.Visible = True

May I confirm is the code client is using correct? I have already engaged our tech team for the missing workspace add-in but just want to make sure if the code is correct when calling Excel via VBA

Answers