I have a workbook that I want to save a copy of every month. I had planned on using scheduled tasks and a batch file to open the file, but then I realized I didn't have a way to call the macro. In the past when I've run into this I've used a workbook open event that only triggers if the workbook is open at a certain time. I'd prefer not to do that in this case, as it is likely that the time and date that the file opens will need to change occasionally. I'd prefer to only have to update the scheduled task when that happens.
I've done some searching and the suggestion seems to be to use VBS to take care of the whole thing? Unfortunately, I can't search the forum for just VBS, and my Google searches seem to come up with lots of fragments that get me part way, but I'm having trouble putting the whole thing together. So hoping I can ask a couple of questions here.
1) Given my needs is VBS likely my best bet, or is there a simpler way to do this?
2) Assuming VBS is the way to do this, does the VBS file replace both the batch file and the macro? I.E. I use scheduled tasks to call the VBS file and that file will contain both code to open the workbook + my macro code and I would not have my macro stored within the workbook itself?
Bookmarks