ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto save at intervals to new filename in excel (https://www.excelbanter.com/excel-programming/344520-auto-save-intervals-new-filename-excel.html)

Lokesh Patel

Auto save at intervals to new filename in excel
 
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.


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com