VBA to Create PDF File on Sharepoint and set .ContentTypeProperties() values

[pjmorris]

HI,

Using VBA I'm able to create and save an excel file to SharePoint and set relevant tags using the .ContentTypeProperties() value. In order to publish the spreadsheet I want to create a PDF version in the same location, but seem to be unable to do so because the 'tags' aren't set.

Grateful for your thoughts - even if that's only 'It can't be done!".

Regards

Peter