I have a project that needs to monitor data that is published on a website.
http://www.gcmtravel.com/gcm/detectors.jsp
I found out that excel can import the table easily and even refresh it.
However, I need all the data that it imports. For instance, the web query
changes
the current values to the new values when it refreshes. I either want the
old values to be saved in another file or moved to other cells.
I have tried to look up macros and such, but have had no help.
The website refreshes every 4 or 5 minutes. Is there a way
to save the file every 5 minutes with a new name such as the time?
Or can you think of any other way I may be able to do this.
Thank you for any help.