![]() |
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