For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

How to launch Excel with only Eikon add-in enabled

We would like to launch excel with only the Eikon add-in enabled i.e., all other add-ins are disabled. We can do this with other add-ins by creating a simple batch file (see below sample) but we cannot get it to work for Eikon as it tries to open the file.

"C:\Program Files (x86)\Microsoft Office\Office15\Excel.exe" /safe /x "C:\Users\barramej\AppData\Local\Thomson Reuters\Eikon\EikonDesktopDataAPI.dll"
pause

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
18k 21 12 20

Hi @janice.b

You can edit registry to prevent add ins to be loaded.

- Disable an Add In as example

- Enable an Add In as example

From the concept above, you can write a script to edit any Add Ins LoadBehavior value to 0 to disable it.

Here is example to make a command line.

So in your batch file, you should have:

- Disable all the add ins you do not want

- Launch Thomson Reuters Eikon - Microsoft Excel by using this command

"C:\Program Files (x86)\Thomson Reuters\Eikon\Eikon.exe" -officeexcel


ahs1.png (98.6 KiB)
ahs2.png (95.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
39.2k 75 11 27

I'm afraid I'm not entirely sure what you're trying to do here, as specifying a DLL in the list of files to be opened by Excel makes no sense to me. Additionally EikonDesktopDataAPI.dll file has no relation to Eikon Excel COM add-in.
As far as I know /safe command line switch for Excel.exe ensures Excel starts in safe mode, which means all COM add-ins are disabled. In other words no COM add-in can be loaded into Excel running in safe mode, although the behavior may differ depending on the version of Excel. It appears that in latest versions you may be able to use /a command line switch to specify an add-in to load by ProgID. I have not tried this myself, but this is the command line you can try to use if you have Office 2013 or higher:

excel.exe /s /a PowerlinkCOMAddIn.COMAddIn
To the best of my knowledge in earlier versions of Excel /a command line switch is not available. Instead of a batch file you could use the following VB Script, which starts a new instance of Excel and unloads all COM add-ins except Eikon Excel.
Dim m_Excel
Dim i
Set m_Excel = CreateObject("Excel.Application")
m_Excel.Visible = True
For Each m_COMAddin In m_Excel.COMAddIns
    If m_COMAddin.progID = "PowerlinkCOMAddIn.COMAddIn" Then
        m_COMAddin.Connect = True
    Else
        m_COMAddin.Connect = False
    End If
Next
Wscript.Quit
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea