Update Web Query Without deleting old data, just update new ones.

Hi ,
I have created a Web query in Excel I put it to refresh every 10 minutes and all the old data is removed with the new data .
This is the website in question

http://www.dmxmusic.com/guide/whats_...channel_id=100

I would like excel to update with the new songs played without deleting the songs that played before, in other words I want to get a list of all songs played in a day.

Thank you very much in advance.

Hi, welcome to the forum
see attached file
Try this:

This sub calls itself every 10 minutes

Please Login or Register  to view this content.

Do you want the sub to run automatically when the file is opened? Add this to the ThisWorkbook module

Please Login or Register  to view this content.

The link worked for me. But perhaps you could try removing it and recreating on your Mac - there may be some difference in the way Excel for Mac does the linking

Excel 2003 - create a file with the 2 worksheets named as per my download, add the data import link etc and place the VBA in a general module. (Hopefully it will work - the VBA is basic)

Glad it worked for you 😀
Please mark thread as solved - see thread tools at top of thread