Mac OS Sonoma - Excel Macros failing since upgrade - SaveAs seems to be failing

Hi all,

I have the following macro, which has worked without issue for around 4-5 months, Since upgrading my Mac to Sonoma last night, my macros are now failing. As per the attached screenshots, could anyone please help?!

Wonder whether it might be something to do with file paths or something, as the debugger seems to be landing at the SaveAs lines?

The script is as follows:

Please Login or Register  to view this content.

Definitely seems to be the Save aspect of the macros, as others (such as below) are still working without issue.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance!

Olly.

Also posted on MrExcel.com: https://www.mrexcel.com/board/thread...iling.1245948/Save As csv File macro Debug.jpegSave As csv File macro Debug.jpeg

Apologies, I forgot to include what the initial error reads - as per image
Attachment 844052

This is now resolved. There is a patch in version 16.9 that fixes it. I don’t yet have this version myself, as not on the Beta channel, but another user has confirmed it now works. The solution is, to wait!

Hi,

as the obvious solution is to just use the correct FileFormat option ! …