Hi,
I am trying to save an Excel file to a SharePoint website using VBA. The SharePoint library is set up with multiple Content types (Documents, Compliance, Operations, Policies). I am able to save files to the Default Content Type "Documents" with the code

ActiveWorkbook.SaveAs FileName:= _
"https://esharepoint.com/sites/Projects/ES/COA/Documents/" & FName & ".xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False


If I use the code
ActiveWorkbook.SaveAs FileName:= _
"https://esharepoint.com/sites/Projects/ES/COA/Documents/Forms/Compliance/" & FName & ".xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

I am able to access the file via a mapped drive in Windows Explorer (https://esharepoint.com/sites/Projec...rms/Compliance), but it is not available via the SharePoint site.

What code will allow me to save the file with a different SharePoint Site Content Type and have the file visible via SharePoint?

Thanks