Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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
Hello @janice.b
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text beneath the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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
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.COMAddInTo 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
