Forum Discussion
Error 1004
Hello I will be very grateful if you help me. I have a Mac mini with Sonoma 14.1. Before the update to Sonoma worked everything well without any problem. After update to Sonoma, my Excel file shows...
Try recording a macro when you export the sheet to PDF (File, Export, XPS/PDF button). Once the PDF has been created, stop recording and compare the newly added macro to the one causing the issue.
- Hello
I did like you said. It just added " ChDir "/Users/NAME/Desktop/FOLDERNAME/" " and the rest is same.
When i save manualy there's no problem. But when i use button it gives same error.- Does it help to add the folder to the trusted folders (if that is something Mac Excel allows you to do that is)
- Thanks for response and sorry for late respons.
When I change the name of the folder, Excel ask for permission to trust the folder. But after 12hours the error occurs again.
I have separated the folders. So saving pdf's to one folder and save as excel (.xlsm) to another folder. For save as pdf there's no problem anymore. For saving pdf is working.
But the problem is just now only on save as. The error occurs on save as xlsm file. So I have to change folder name again etc. Do you have any ideas?
