nhrav,
I have attached the programs, but you are going to need to modify a few things or make sure to put your template in a certain place.
Currently, this program use C:\Temp (that is a file path) as the default directory and it is looking for a file called Patients.xlt (this is the test template I was using). It will also save all the created workbooks to that file. If you create a template, save it to C:\Temp, and call it Patients.xlt the program should run as is. Otherwise you are going to have to modify a few things.
These two lines will have to be changed. The items in red will need to be updated to where ever you store your template and to the folder you want the new workbooks to be created in.
I am sure a developer would rig this program so it could just prompt you for this information. Unfortunately, I am not a developer, but rather just someone who has been using Excel on a daily basis for about the paste 8 years.
When you open Tabs.xls it has a place for you to enter the starting date and how many months you want to go out from there. It will default to the current date and 1 month. I also have it set so it will not create more than 12 months at a time. I did this as a safety net so you don't end up with 50 new workbooks all at one time. If you just want to create 1 month, just enter the first day of that month and 1.
Both the months and the days of the week are in Spanish.
Hope this program meets your needs! It was a little more involved than I had anticipated, but I really like programming and I always learn something new that ends up as a benefit not only to you, but to me also.
Bookmarks