Run-Time error ‘1004’ There several possible reasons

Are you trying to add date into filename?

You don't need to use the file extension in the filename when declaring the file type.

Why are you saving as .xls?

The error seems to be occurring in the C:\Windows\System32 folder which is (or can be) a protected Windows folder. You may need special permissions to safe files in this folder.

Does the error occur if you save the file in a non Windows protected folder?

Attach an example of the workbook