Market refresh

[summit]

Hi there,

I now have the excel multiple sheets quick link running

I also have a macro which puts -3 in Q2 at 00:05 and then -5 at 00:10

This works perfectly for refreshing the market and then choosing the first race of the next day.

However, I have two markets UK and AUS ( which loads perfectly on start up) but the above only refreshes the UK market.

Is there any way to refresh both markets? Currently all the AUS markets are refreshed out of the page.

Thanks for any help.

[Daywalker]

Do you have UK in one sheet and aus in another?

Would you need to put -3 in both sheets? Maybe at slightly different times.

Also, you can choose to select first race in qpl when updating. The option is on the page when you link to excel.

[Captain Sensible]

You need to run two instances of BA , it'll only refresh the quick pick list for the first tab using the default markets BA is set to load. It won't use the markets from the excel multi link.

[summit]

Great thanks.

So...I can run two instances of BA but both instances linked to the same worksheet?

I want to run both UK and AUS on the same worksheet.