I have an excel file that logs data every few seconds from an OPC server device.
Can someone provide me with code that will automatically save my excel file every day at the same time to a filename that includes the current date. I would also like to clear the data from my open file and start logging new data from the top immediately following the save. I already have the code to record the data. I just need a way of saving the file without generating any dialog boxes that would require a user to acknowledge the save.
Can someone provide me with code that will automatically save my excel file every day at the same time to a filename that includes the current date. I would also like to clear the data from my open file and start logging new data from the top immediately following the save. I already have the code to record the data. I just need a way of saving the file without generating any dialog boxes that would require a user to acknowledge the save.