(Solved) – How to copy and paste an existing .xlm workbook file ona certain date and time without opening the existing file?

(solved)-–-how-to-copy-and-paste-an-existing.xlm-workbook-file-ona-certain-date-and-time-without-opening-the-existing-file?

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?
Thanks
SATAMAN

Leave a Reply

Your email address will not be published. Required fields are marked *