help with betfair tracking spreadsheet

Application.DisplayAlerts = False

plus need to set two parameters in the vb code that creates the querytable,

qryTable.BackgroundQuery = False

qryTable.Refresh BackgroundQuery: = False

Haven't got the original spreadsheet and can't remember if I changed anything else, might not be called qryTable in the original.

Setting these to True - which may be the default - causes the pop up.

thanks for reply.
both of the above are set correctly. what happens is that when tracking a market every 5 secs for example, and a goal is scored, the market suspended message comes up.a pop then appears saying error with web query. it has to be clicked to get rid of and then the market table starts refreshing again. I have amended my spreadsheet to place a bet sometimes in the event of a goal.the code wont execute if a pop up takes all of the focus.
I had really hoped that application.displayalerts = false would prevent the pop up but it doesnt.
just wondered if there was any other code that would get rid of all alerts for example?

I'll take a look again, I had a similar problem with the pop up and managed to solve it.

Problem is my spreadsheet has very little of the original code and can't remember exactly which bit worked.

Before posting the earlier reply I changed those settings to true and the pop up reappeared on market suspension.

cheers Unk,
As a thought I have created a new webbrowser form.
I have then amended the refreshalltables( ) code with an IF statement. It navigates to the table connection address and interrogates the HTML coding to see if the strings "market suspended" or "unexpected error" are found before going on to refresh the table if the above are not found.

Unfortunately this didnt work. It works when I tested by using old HTML pasted into a cell, but not in a live scenario for some reason. Its almost as if when a market becomes suspended or closed the tables are refreshed automatically or force refreshed, despite code being in place to resist this......

very interested to see what you did on your spreadsheet to overcome this.

thanks

**ing

i am also having this problem. i have spent a very long time learning vba in order to get the sheet to do what i want (in fact, unk you started me off and helped me out months ago if you remember), only to have this put a stop to my sheet after a lot of work. VERY frustrating and i would be interested if anyone could shed some light on this. i can currently only track one race as the pop up stops any further refreshes. this is the only thing stopping me now and is driving me flippin mental......

actually, just cracked it. there is a 'public sub forcerefresh()' that needs to be set to false too. on the query table, i did as unk suggested and i set refresh period to 0 (not sure if that helped, i just did!)

ll works fine now without the pop up. Sorted!!

2009 Flat Semi-Detached Detached Terraced total
Number of Sales 95 65 65 35 260
Average price £ 147385 174503 252359 166313

total sales 14001575 11342695 16403335 5820955 47568560

2008 Flat Semi-Detached Detached Terraced
Number of Sales 214 91 157 96 558
Average price £ 145452 220148 314814 178844

% change 1.33 -20.73 -19.84 -7.01

total sales 31126728 20033468 49425798 17169024 117755018

2009 average price 182956
2008 average price 211030.4982
change -13.30352648

:x

ttt

.

What ever happened to this?

.