Labs Chat
There is currently 1 person viewing this thread.
I have recently downloaded the tracking spreadsheet from the labs site
have it working great, BUT:
any ideas how to stop the error pop up message
"This Web query returned no data"
It happens when the race has finished or any market that suddenly suspends. the spreadsheet wont continue until you have clicked ok. No good if you have amended it like I have to place bets on different markets once prices are met.......
Im sure this must have been asked before, but I cant find anything to overcome.
I have tried
application.displayalerts = false, and I have also tried on error resume next to no avail.
I also tried on error go to .......
any ideas, or can someone show me any threads that have already covered this topic?
cheers
have it working great, BUT:
any ideas how to stop the error pop up message
"This Web query returned no data"
It happens when the race has finished or any market that suddenly suspends. the spreadsheet wont continue until you have clicked ok. No good if you have amended it like I have to place bets on different markets once prices are met.......
Im sure this must have been asked before, but I cant find anything to overcome.
I have tried
application.displayalerts = false, and I have also tried on error resume next to no avail.
I also tried on error go to .......
any ideas, or can someone show me any threads that have already covered this topic?
cheers
sort by:
Show
per page
Replies: 13
|
By:
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. |
|
By:
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? |
|
By:
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. |
|
By:
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 |
|
By:
**ing
|
|
By:
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......
|
|
By:
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!! |
|
By:
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 |
|
By:
:x
|
|
By:
ttt
|
|
By:
.
|
|
By:
What ever happened to this?
|
|
By:
.
|