VBA file save as folder based on date

Good morning everyone,

My mind is a little boggled lately and I'm having troubles narrowing down my VBA. I would like to save a daily file to a specific folder based on the date of the file. Every daily file gets saved in "D:\Daily Reports\" but there are sub folders for each year (NB 2014 Daily Reports, NB 2015 Daily Reports, etc) and then each year folder has a sub folder of "1-January" through "12-December". The month numbers are so the folders are sorted chronologically when you open the main folder. I am using a userform to grab the date in d/m/y format, is there a way to pull the year and month from that (textbox name="NewDate") and have it save the workbook with filename "MMDDYYYY DR.xlsm"? For example, today's report would be "D:\Daily Reports\NB 2015 Daily Reports\6-June\06122015 DR.xlsm". And a side note, I would like to keep it so the dialog box opens and the user can confirm where it is saving and so that they can also see if the filename already exists. Too many non-computer abled people will be using this file and I don't want old files overwritten on accident!

Thank you!

Please Login or Register  to view this content.

bump, any suggestions?

Still no replies, still need help. Thank you!