..RefreshOnFileOpen = False
..BackgroundQuery = False
..Refresh BackgroundQuery:=False
..RefreshPeriod = 0

You might want to try adding what I put up there to your macro's code and
that should prvent it from updating from the web everytime.

Alex


"Duane" wrote:

How would I program a web query without connecting to the web? Is this
possible? I program one query, and I have several others with similar
information except maybe the year, or something small. In the old excel, I
could edit the address in excel...with 2003, it connects me to the web
everytime and it is much slower.

Thanks for any help.