beforeUpdate event of Web Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

johnbest - 24 Jan 2006 10:59 GMT

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? :eek:
2. Copy the data ;)

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

:confused:

Please......
Thanks in advance

Have a nice day
JohnBest

Signature

johnbest

Reply to this Message

Tom Ogilvy - 24 Jan 2006 14:04 GMT

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.

Signature

Regards,
Tom Ogilvy

> Hi there
>
[quoted text clipped - 13 lines]
> Have a nice day
> JohnBest

Reply to this Message

johnbest - 25 Jan 2006 13:37 GMT

Hi Tom

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

Thanks again :)
Have a nice day
JohnBest

Signature

johnbest

Reply to this Message