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 Auto_Open 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

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

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

--
Regards,
Tom Ogilvy

"gr8guy" wrote in message
...
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 Auto_Open 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

thanks Tom, you always a great help to everybody!

Rgds,

Eijaz

"Tom Ogilvy" wrote in message
...
See Chip Pearson's site for sample code on repetitively running a
procedure

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

--
Regards,
Tom Ogilvy

"gr8guy" wrote in message
...
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 Auto_Open 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