This Macro will create a series of 12 files in the same Directory as this file is stored
It is recommended that you create a new empty folder, save a copy of this file in that folder, and then run the macro.
Each new file will be named Jan.xls through to Dec.xls
Within each file, there will be an individual sheet for eaach day of the Month, corresponding to the month of the filename.
The user will be prompted to enter the Year number, 2007, 2008 2009 tetc. At the begiining of the macro to ensure that
the correct number of sheets is created for Februray of that year.
Enter 0 in response to Year prompt if you want to cancel running the macro.
If files of the same name exists in the folder, you will be asked if you want to overwrite. YES will cause you to LOSE
your EXISTING file, No will skip that month and proceed to next month.