I want to retrieve the two different data table from the same instrument. After, I follow the step from COM APIs for use in Microsoft Office tutorial, I try to modify the code. However, I can get only one table at a time.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
I just find the solution on my own by naming the different query name. For example, m_RHistoryQuery1 and m_RHistoryQuery2. And then call it together.
@pongchai.paitoon, thank you for posting your solution :-)
Setting up VBA in Thomson Reuters Eikon
Login to Reuters EIKON via VBA with username and password
Can I find the default Eikon for Excel RHistory fields for an instrument using the COM APIs and VBA?
API Code for Eikon
Performance issues when fetching large amounts of data