Can't get Excel 2010 to activate an RTD COM Add-in

[batman]

I realize that it's a long post - please bear with me

I re-installed Sterling Trader Pro (a stock trading application, for which I have a Sterling account) with the Excel RTD (Real Time Data) option instead of the DDE option. I plan to update my Sterling-centric Excel 2010 trading application to use RTD to access Sterling's real time market feed. The entire installation was uneventful and reported as successful.

HOWEVER Excel lists the RTD add-in in Options > Add-ins as an INACTIVE COM add-in. When I select it in Manage COM Add-ins, Load Behavior states "Not loaded: A runtime error occurred during the loading of the COM Add-in", no error code given. And of course the add-in doesn't show up in Excel's Add-Ins ribbon.

With the very same Sterling installation on my HP laptop (Win 7 Ultimate) the RTD add-in properly appears in the Excel (2007) active list and in the Add-ins ribbon, and I can create working RTD formulas with it. But the laptop is not suited to development work. On both PCs (and tech support's) the RTD add-in is identified and listed as mscoree.dll, which is a Win System file.

Back to the desktop PC. Sterling tech support confirms that I have all the Excel Add-in and Trust Center options set correctly. Win 7 Pro (which I recently clean-reinstalled), including .Net Framework 4, Client & Extended, is fully up-to-date. In all other respects the entire system (3GHz Intel CPU, 4 MB RAM, big hard drive) runs fine.
Here's what I've tried so far, to no avail:

1 ran Malwarebytes and Norton - neither one found any bad stuff of any kind
2 ran sfc /scannow from elevated cmd prompt - reported no integrity violations
3 tried to register the RTD add-in's five dlls with RegSvr32; in each case it said the dll was loaded, but "entry point DllRegisterServer was not found".
4 repaired Office 2010 (Home & Student) through Control Panel, Programs & Features
5 adjusted some Services to match laptop (mostly the startup mode)
6 compared group policy settings - couldn't see any meaningful differences

Can anyone suggest how to get this RTD add-in to activate and work in Excel on this particular PC?

[Alf]

As you can have more Excel versions installed on the same pc have you considered installing Excel 2007 on your "main" pc as well to run this add-in?

http://office.microsoft.com/en-us/ex...102597134.aspx

Alf

[batman]

I responded to Alf several days ago, but it doesn't appear in this thread, so I don't know if he saw it.

At Alf's suggestion I installed Excel 2007; the installation was uneventful and successful. However, it made no difference. The Sterling RTD Excel addin still won't move from the inactive to the active addins list. As before, when I select the addin (mscoree.dll) in Manage COM Add-ins, Load Behavior states "Not loaded: A runtime error occurred during the loading of the COM Add-in", no error code given.

I'm trying to use the SysInternals Process Monitor utility (Procmon.exe) to see what's happening (or not happening). But I'm not sure what to look for in the voluminous data in produces.

[Alf]

it doesn't appear in this thread, so I don't know if he saw it.

Sorry I've been away for almost a week so this is the first chance I have to check messages in forum.

Googling for problems for this add-in I've seen several posts where this add-in worked without a hitch in Excel 2007 environment but upgrading to excel 2010 this add-in stopped working.

http://www.sevenforums.com/microsoft...d-com-add.html

http://www.ozgrid.com/forum/showthread.php?t=154521

http://www.techsupportforum.com/foru...el-654816.html

There seems to be a general warning against using the 64 bit Office version but from you first post I think you are using the 32 bit version so this could not be you problem.

Don't know what else you could do. Perhaps but this is no guarantee this will work you could start by uninstalling all office versions from you computer. Then install Office 2007 and test if the add-in works. If so you could then do a custom install of Office 2010 where you keep the Excel 2007 and see if the add-in works even if excel 2010 is installed.

Alf

[arlu1201]

Thread moved to CS, hence closed.