@ john davis it kind of worked once but when I went to do it again it gives me a 1004 error again and my current active workbook is renamed to sheetname29_Jun-17
It worked when I tested it. I'd have to see the actual code you are using. There is nothing in the code which would change the name of the workbook and there would be a space between the workbook name and the current date.
Bookmarks