Hope this is the right forum; if not, please direct me to the right one.
In Excel 2007 I am filling in a document property programmatically in an Excel 2003 spreadsheet, and creating/filling a custom one.ÃÂ Just FYI, I use the following VBA code:
ActiveWorkbook.BuiltinDocumentProperties("Company") = "TEST COMPANY NAME"
ActiveWorkbook.CustomDocumentProperties.Add "Manager's Name", False, msoPropertyTypeString, "TEST MANAGER NAME"
Then I save the document to a SharePoint library.ÃÂ Right now it is saved as a 2003 version spreadsheet (.xls).ÃÂ There are a Company column and a Manager's Name column in the SharePoint library, and Microsoft's online documentation says the properties should populate the corresponding columns in the library.ÃÂ But they don't!
That's my problem--getting them to populate.ÃÂ Incidentally, thinking that the spreadsheet version was the problem, I have tried saving these documents both as 2003 spreadsheets and 2007 spreadsheets in my code, but the SharePoint columns never populate either way.ÃÂ The only way I can do it is by manually filling in the document property from the UI.
Does anyone know what I'm doing wrong, either in Excel or SharePoint or somewhere in between, to cause this?ÃÂ Is there a non-code solution to the problem?ÃÂ I can do some C# code if I h
View Complete Post