Hi there! I haven't worked with Excel Macros for a few years so please bear with me.
We have a data logger that logs temperature points for a specific piece of equipment. We have a pre-existing Excel macro that puts those data points into a table, and then into a chart. It records a new data point every minute.
What we'd like is a macro that can automatically take all of the data points for a day (so, 1,440 points) and save them into a new workbook with the date as the name. Preferrably at midnight every night. We would leave Excel running on a network computer 24/7.
If there's a way to do this automatically at midnight, without needing to click a button, please let me know. Thank you for all of your help, we really appreciate it!
Bookmarks