SharePoint file properties (columns) can be saved into Excel workbooks, but these types of properties are not saved in custom properties, except Title and Description properties.
VBA can get the SharePoint file properties by using ThisWorkbook.ContentTypeProperties().