Saveas Macro with current date

Yes, that's a separate issue. In Excel, we use ActiveWorkbook rather than ActiveDocument (you would use that in, for example, Microsoft Word).