Set default folder for save dialog in Excel for Mac

I have tried several solutions (including some from the Internet) to change the save-file dialog default folder.
None have worked on Mac Excel/VBA.

Can anyone share some working code for Mac (Big Sur 11.7.2) Excel/VBA that I can use to set the default folder for a file-save dialog, before opening the file at the end of a hyperlink?

Here is what I want:

Please Login or Register  to view this content.

Many thanks.