Create a folder seamlessly with VBA. Link to tutorial https://www.thesmallman.com/create-folder-with-vba
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.