running a webquery after every 5 secs

[gr8guy]

hi,

i have a webquery which i want to run automatically in excel after every 5
secs. what i want to know is where do i attach the code so that it runs
automatically every 5 secs using the

Application.OnTime Now + TimeValue("00:00:05"), "my_Code"

is it in an Autpen Macro, or ThisWorkbook or any
Worksheet_SelectionChange or Worksheet_Change events???

I would appreciate if somebody could point out where i am going wrong & what
needs to be done to run it automatically every 5 secs without USer
intervention.


Rgds,

Eijaz

 

[Tom Ogilvy]

See Chip Pearson's site for sample code on repetitively running a procedure

http://www.cpearson.com/excel/ontime.htm

 

[gr8guy]

thanks Tom, you always a great help to everybody!

Rgds,

Eijaz