How to Process Query Data after Query is Refreshed

[rajpuneyani]

Hi all,

I have a spreadsheet which has a webquery which fetches data from a
website at specified intervals. Now everytime the query is refreshed,
the old data is overwritten so What I want to do is that after every
refresh, Do some processing with the refreshed fetched data before it
is overwritten in the next refresh.

Is there any post query refresh macro or event that I could use to do
my post refresh processing ? Any other way of what I want to achieve.

Any help would be appreciated.

 

[Dick Kusleika]

You can use a class module as described here

http://www.dicks-blog.com/excel/2004/06/classes_other_e.html

 

[rajpuneyani]

Thank you so much..I was exactly looking for this.
I appreciate your quick response.

Regards
Rajes