How to copy and paste an existing .xlm workbook file automatically on a certain date and time without opening the existing file?
I have a vba workbook file which I use to record certain data monthly. At the end of the month I must save this workbook and start a new workbook file by copying the existing file and thereafter I manually revise certain data ( such as dates, names, figures etc.)before I start using it again to record my usual daily data.
I would like to have copy-paste-revise actions automatically at a certain date and time: for example 1st of the new month at 07:00 AM.
I will appreciate any suggestions on how to go about it?