Web Query - Listing data before an auto refresh brings in new data

Hi, I'm new to the site as a member but have looked in from time to time to get a few pointers. No-one has asked this question though so I hope there is an answer that can help.

I am trying to record the usage of toner and fuser consumables on 16 printers. I can Web Query the information in a spreadsheet for each printer easy enough, however, what I am trying to do is automate the information into a list before new information is refreshed.

 Is there anyway this can be done..?

Rob

I'm sure there is, if you have the data in an Excel sheet it can be copied off somewhere at set intervals. There may be an event you can use to to this just after the data refreshes (Worksheet_Change() etc (This code takes the data in A1:A30 and pastes it to the same range on sheet2 if there is any change in the data

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A1:D30").Copy Destination:=Worksheets("Sheet2").Range("A1:D30")
Application.EnableEvents = True
End Sub

It might help to know a little more detail to be more specific, but I am sure it's do'able.

Rob:  You can also use QueryTable events, but you'll have to use a custom class.  I'd use the BeforeRefresh event http://www.dailydoseofexcel.com/archives/2004/06/21/classes-other-events/