Excel population with Lookup Fields
Is there a way to populate information in Excel through OTA?
Re: Excel population with Lookup Fields
Yes, because Excel macros use VBA, VBA allows the use of COM objects and OTA is implemented as a set of COM objects.
Open an Excel workbook. Start the Script Editor. Add a reference to the OTA library. You can then declare and manipulate all the objects described in the OTA reference manual. Most of the examples listed in that manual can be just pasted in the VBA script as is.