beforeUpdate event of Web Query

[johnbest]

Hi there

On sheet1, I have a web query which refreshes every 5 mins.
On sheet2, I want to copy the data (in rows) of the sheet1 before the
web query refreshes.....
I am dividing this question in two parts :
1. how to catch the beforeRefresh Event?
2. Copy the data

Out of these two parts I need guidance, help on the first part only


Please......
Thanks in advance

Have a nice day
JohnBest

 

[Tom Ogilvy]

http://support.microsoft.com/kb/213187/en-us
XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

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

methods presented should be good in any version after and including xl97.

 

[johnbest]

Hi Tom

Thanks for your reply...
It helped me a lot

Thanks again
Have a nice day
JohnBest