Web Query Refersh Interval

[Guest]

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

 

[Frank Kabel]

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

 

[Guest]

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