I am able to upload files to Sharepoint through VBA but I'm not able to update these properties to have their properties updated with 'Document Status' and 'Confidentiality' Fields.
Until these are updated, others are not able to see them.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
You could try using .ContentTypeProperties as discussed in this thread.. https://stackoverflow.com/questions/17406585/vba-set-custom-document-property
Then try this link Update SharePoint Metadata using VBscript
It should help. Take special notice to the multiple choice information at the bottom if you are using that type of control.