I’m getting the attached run-time error message with the attached vba code “Save as with the new file name”. I’m in Excel MS 365.
Run-Time error ‘1004’ There several possible reasons
- gdraco123
- Thread is marked as Resolved.
-
-
-
Are you trying to add date into filename?
-
No date.
-
You don't need to use the file extension in the filename when declaring the file type.
Why are you saving as .xls?
-
Took out .xls, but still getting same error message.
-
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
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!