I am developing an Excel Add-In to list, select, and retrieve an OData source. I'd like to be able to call a macro that opens excels Data / Get Data / From Other Sources / From OData Feed and fills in the URL field according to the user's previous selection.
I've searched microsft documentation and google but find no mention of executing a macro from the Office javascript library.