View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JustinB
 
Posts: n/a
Default web query help.. delay?


is it possible to put a delay before a web query executes?

i have an excel spreadsheet that has about 8 tabs in it. when you
change the value in a particular cell of the first tab, the other 7
will recognize it and update the data for the new value.

the problem is that once the queries begin to refresh, i get an
"invalid web query" error. if i press ok and then refresh the queries,
it will fill in more data, and then give another error. after about 2
or 3 of the same errors and retrying, it will eventually populate the
page fully and give no errors.

i believe this has something to do with the queries are running a bit
faster than the web pages load. is it possible to put a delay within
the query before it executes?


edit: by the way, this is for fundamental analysis on stocks. enter a
symbol and the fields all populate automatically. i have already
integrated an excel spreadsheet to a paysite (investools), and it works
fine. now i am trying to make one that runs off of msn money's site, and
its giving me trouble.


--
JustinB
------------------------------------------------------------------------
JustinB's Profile: http://www.excelforum.com/member.php...o&userid=34886
View this thread: http://www.excelforum.com/showthread...hreadid=552521