Web Query Refersh Interval

Hi

I am using Excel 2002 to get a web query, it work fine but the AUTOMATIC REFERESH Interval is min 1 minute.

I want set the Interval to 20 seconds, can any one help me about how to?

Using VBA ? can give some example code ?

Thank you

Kelvin

Hi
AFAIK this is the best you can get. If you need shorter intervals you
have to use the OnTime method and program your data access yourself

--
Regards
Frank Kabel
Frankfurt, Germany


Kelvin wrote:
Hi

I am using Excel 2002 to get a web query, it work fine but the
AUTOMATIC REFERESH Interval is min 1 minute.

I want set the Interval to 20 seconds, can any one help me about how
to?

Using VBA ? can give some example code ?

Thank you

Kelvin

Thanks

I using onTime method, but still have problem with refresh
Here is the code of refresh

==========

Sub Refresh()

Selection.QueryTable.Refresh BackgroundQuery:=False

End Sub

===========

It can refresh every 20 second, but I must point the sheet, it I want to see other sheet it will ERROR 400

Help me please

Thank you

Kelvin





"Frank Kabel" wrote:

Hi
AFAIK this is the best you can get. If you need shorter intervals you
have to use the OnTime method and program your data access yourself

--
Regards
Frank Kabel
Frankfurt, Germany


Kelvin wrote:
Hi

I am using Excel 2002 to get a web query, it work fine but the
AUTOMATIC REFERESH Interval is min 1 minute.

I want set the Interval to 20 seconds, can any one help me about how
to?

Using VBA ? can give some example code ?

Thank you

Kelvin