API Support Forum
OEC API > API Support > Non of the example you provided works
Author Topic: Non of the example you provided works
(2 messages, Page 1 of 1)
Moderators: VPfau
NAkesson
Posts: 11
Joined: Aug 10, 2011


Posted: Aug 17, 2011 @ 05:37 AM             Msg. 1 of 2
I try to get som ideas from the attached workbookexample. But non of the example is working ("Sample COM Book.xls" and "Sample Add-In Book.xls" for dde-linking.

For "Sample COM Book.xls", I could not check the "OEC.functions" box, because when I tried to do the "automation" task I can't find "OEC.functions" in the list (I followed the DDE manual exactly).

I could get the quoteinformation if I write the DDE-link manually (or automated) and doing a initiate/request/terminate through VBA.

The "Sample COM Book.xls" is not working so I did some changes so it begin to run, but then I get a "Active-X" error message.

Could this depend on that I have a Swedish version of WIN7 (64-bit) and office 2010. Sometimes this could be a problem when the "program files" directory is hardcoded. All OEC software is in my "Program(x86)" directory.

I have no "program files" directory on my computer...

NA
VictorV
Posts: 746
Joined: May 08, 2007


Posted: Aug 18, 2011 @ 09:39 AM             Msg. 2 of 2
Hello, I think the trouble is our COM registered in x86 namespace of your computer, but Office is looking the registration in 64-bit one. I submitted the issue to our development queue.

Victor Vins
Lead Software Developer