I have tried several solutions to set 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:

Sub SimpleExample()
    Dim Website As String
    Website = "https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip?24e1f8f75f24ff1735cadf130163f7d0" ' Hyperlink to follow
    <some code here to set the default save folder and hopefully indicate "Replace" for the dialog, without having to specify them manually>
    ActiveWorkbook.FollowHyperlink Address:=Website, NewWindow:=True 'Open Website
End Sub
Many thanks.