¿ªÔÆÌåÓýThe problem here is that the secIdList property is actually a generic object of type ComList<ComTagValue, TagValue>, and generic objects cannot be mapped into COM objects (which is why the Excel Object Browser shows it simply as being of type Object). ? So you can't access any of the members of this type. However all is not lost because the ComList<ComTagValue, TagValue>, ?type implements the IList<ComWrapper<T>> interface, which should enable the members of the list to be iterated over using For Each, something like this: ? Dim s As String Dim tv As ComTagValue For Each tv In ContractDetails.secIdList ??? s = s & tv.tag & ": " & tv.value & ";" Next ? MsgBox s, , "SecIdList" ? I haven't been able to actually try this because at the moment I can't seem to make the damn ActiveX Excel workbook work at all (I rebuilt the ActiveX control from the latest files in the Github repository, and at the moment neither the C# API nor the ActiveX API will connect successfully ¨C they just hang). ? Richard ? ? From: [email protected] <[email protected]> On Behalf Of praditik@...
Sent: 18 February 2021 14:17 To: [email protected] Subject: [TWS API] CUSIP/ISIN in ActiveX API using VBA in Excel ? Hello,
|