I have VBA code written for my Excel document. This code saves the workbook in Sharepoint site and sets the metadata for the document library that the workbook is saved into.
Working code to set meta data for Excel workbook.
CustomerNumber = Range("C1").Value
ActiveWorkbook.ContentTypeProperties("Customer Number").Value = CustomerNumber
All of the metadata types are working except for the Hyperlink type. Whenever I try to set this metadata field I get a Run-time error '91'
This is what my code looks like to set the Hyperlink metadata
ReportOutputFile = path & Filename & ".pdf"
ActiveWorkbook.ContentTypeProperties("Report Output File").Value = ReportOutputFile
What am I missing? What is the correct way to set the Hyperlink Metadata from a VBA script in Excel?