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.

--
Regards,
Tom Ogilvy



"johnbest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> johnbest
> ------------------------------------------------------------------------
> johnbest's Profile:
http://www.excelforum.com/member.php...o&userid=29694
> View this thread: http://www.excelforum.com/showthread...hreadid=504406
>

[johnbest]

Hi Tom

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

Thanks again
Have a nice day
JohnBest