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

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" wrote in
message ...

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

Hi Tom

Thanks for your reply... :)
It helped me a lot ;)

Thanks again :)
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