Hi,

I'm trying to use VBA Macro to upload the excel file to Sharepoint site and update the properties values.

The macro works perfect for US users, but for European users, they get "Type Mismatch" error on the following line:

ActiveWorkbook.ContentTypeProperties("Business Line").Value = Range("B7")

I also tried

For Each prop In ThisWorkbook.ContentTypeProperties
If prop.Name = "Business Line" Then
prop.Value = Range("B7")
End If
Next prop


but European users still have the same error.

Does anyone know how to solve it?

thanks for your support

CHY