Quick pick list in excel

[Daywalker]

Hi

my excel sheet trades on aus horses, uk dogs, uk horses, then uk dogs again. I have to set it to reload the quickpick list with different markets at different times each day. Is there a way to get the quick pick list into an excel sheet? This way I could load all the markets into excel and set it to change itself.

DW

[GaryRussell]

There isn't a specific function to export the quick pick list to Excel.

If you can write VBA code then you could use the COM function getSports(), getEvents() and openMarket() to build your own list and open the markets. See the user guide. There is an example spreadsheet provided using these functions.

[Daywalker]

Thanks Gary

I've only been using VBA since I subscribed to Gruss, I'm no expert but happy to learn using COM functions

DW