Forum Discussion

mBocuk's avatar
mBocuk
Copper Contributor
Nov 10, 2023

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...
Excel on Mac
Macros and VBA
mBocuk's avatar
mBocuk
Copper Contributor
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.
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 27, 2023
Does it help to add the folder to the trusted folders (if that is something Mac Excel allows you to do that is)
  • mBocuk's avatar
    mBocuk
    Copper Contributor
    Dec 06, 2023
    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?

Resources