Quote from TGregg:
Hi,
I know you mentioned that this was from Excel, and not from VB.Net, but it's kinda strange that VB->ActiveX->TWS works perfectly, but Excel->ActiveX->TWS does not, and is apparently sigificant work (by IB) to support. One would expect that if these were not identical, then they would be nearly so.
Don't blame TWS for it. This is due to inadequate support for ActiveX on Excel. M$ has a long history of launching new hot mechanisms and not keep up work on them till they become 100%. It is funny that DDE at one time was touted as great. Then they kind of hid it onder the table pushing COM, COM+, DCOM, Activex etc. It seems that with Excel you have to go with good old DDE.
I believe that Excel is OK for a quick demo with the TWS-API. If you want more it becomes quickly an inferior tool. Go to VB, C++, Delphi. The best is go to Linux with C++ or Kylix(=Delphi).
nononsense