How to Process Query Data after Query is Refreshed
 

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.
--
Thanks and Regards


---
Message posted from http://www.ExcelForum.com/

How to Process Query Data after Query is Refreshed
 

You can use a class module as described here

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

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"rajpuneyani " wrote in message
...
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.
--
Thanks and Regards


---
Message posted from http://www.ExcelForum.com/

How to Process Query Data after Query is Refreshed
 

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

Regards
Rajes

--
Message posted from http://www.ExcelForum.com