Hi, I have the following macro I use to save a workbook (Help from another forum member who kindly helped me solve it) with the next chronological date.
I have added some code to it in order to open the template, and then save it to the proper folder.
I would like to know where I go or what code to add in order to save the folder in the next month folder.
Ie, in my code it is currently pathed to save it in the folder July.
What I would like to do is add code to the macro to have the macro save it automatically to the next month (August) when it is July, 31 2014
The folder would simply be called August. And on August 31 the next folder would be September and so on.
I don't know if that would require a pop-up prompt asking for the month. My goal is to have one macro that will
1) Open the template from the template folder
2) Save the template as the next chronological date as in the current code
3) save automatically to the next month folder when the next day will be the next month.
4) Or prompt for next month folder name.
Here is my code:
Any help is appreciated.
kind regards
Chris
Bookmarks