Posted: Jul 22, 2011 @ 01:05 PM             Msg. 1 of 2

Hello.

Having made a small modifications to the 'Sample COM Book.xls' I was able to make a remote connection to a running Trader. But the first reference to properties of a class

Glob.c.RequestContracts Glob.c.BaseContracts.FindBySymbol("ESU1")
('UpdateStatus' procedure in 'Config (Login & Settings)' sheet)
causes an error:

[Microsoft Excel: "430 - Class does not support Automation or does not support expected interface"] if error handle placed in class module, or

[Microsoft Visual Basic: "Run-time error '-2147467262 (80004002)': Return argument has an invalid type."] if error handle placed in sheet "Config" module in "UpdateStatus" sub.

System configuration:
XP SP2
Office 2003 SP3
OEC Trader Demo 3.5.0.28
OEC Trader 3.5.0.27
OEC COM API 3.5.0.0 dated 2011.02.28

Link to modified "Sample COM Book.xls":
http://rghost.net/private/15456591/45d2612cb35ad502c4d9b98e76610597

---

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia

Posted: Jul 26, 2011 @ 01:03 PM             Msg. 2 of 2

Your API is out of date since you are getting Automation error, please install the latest at: http://api.openecry.com/Sections/Misc/DownloadFile.aspx?ClientUpdate=0_5003_1&NoCache=83e01304-bf20-46aa-8b39-ca72faa400e4

---

Chris Micciche