http://support.microsoft.com/default...b;en-us;182735
XL97: How to Use the Query Before and AfterRefresh Events


--
Regards,
Tom Ogilvy
"JVLin" wrote in message
...
I am trying to automatically save & close a series of workbooks after
refreshing the 6 or 7 web queries they contain.

There seems to be an AfterRefresh function for query tables, but I don't
know how to use it.

Can anybody help?

JvL