Only one spreadsheet being used after autoupdate

[pmosey]

I am using the autoreload from AutoReloadQuickpickList file in the forum. I have the betting assistant set up to put seperate meetings on seperate sheets in the workbook. This works fine on initial loading, but after auto reloading of the quick pick list all the meetings/races load onto sheet1 instead of to one meeting per sheet. What am I doing wrong please?

[MarkRussell]

Hi,

Are you using the spreadsheet example that reloads the Quick Pick List at midnight?

Regards,
Mark

[pmosey]

Yes, although I have tried changing the time to stop 1 race being backed at about 1am (one Australian and one uk) when the excel multiple loader page is set to only load a race 10 minutes before the off and it was only set to include UK and ireland

[MarkRussell]

Hi,

Ok, the spreadsheet is an example of reloading the Quick Pick List but uses -3 in Q2 to re-populate the Quick Pick List at midnight.

-3 instructs the software to load the Quick Pick List with the markets that you have selected in Preferences after refreshing the Betfair Markets.

But if you want it to re-load into separate venues then you need to use -4.

You can go into the VBA code editor and change the -3 to -4, you can also change the time that this happens if midnight does not suit.

Regards,
Mark

[StuT]

Thanks Mark,

A further question on this if you don't mind.

When using the example AutoReloadQuickpickList if I alter it to reload into separate tabs for each venue (-4) does it start from the current left most tab and replace the existing market in that tab.

And...
What would happen if I coded it to firstly do -4.1 for UK Win and then 4.7 for AUS Win ?
Would it start with the left most tab, open up separate tabs for each UK meeting and then continue opening separate tabs for each AUS meeting ?

[pmosey]

Thanks for your help