Save an open workbook, then open template workbook and close the saved workbook

I have a template Workbook named "LINE11.xls" when opened it creates a new Workbook named "LINE11 mm-dd-yyyy" the date being the day it was opened. What I could use help with is getting it to save and close at mid-night, and then open the template "LINE11.xls" to start a new Workbook for the next day. I am new to vba and this has been messing with me for quite sometime. Any help would be greatly apprieciated. It seems to be close, but I am sure there is a better way.

Please Login or Register  to view this content.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.