I have been experimenting with ContentTypeProperties in Excel.
I use the FSOfilesystem structure to copy an open Excel Workbook to a SharePoint 2010 Document Library.
Is it possible to upload the document AND populate the MetaData at the same time?
MetaData such as "title" "revision" "modified by" "modified date" "comments" etc.
If possible I would like to populate this library from an Excel spreadsheet where columns contain metadata. (Actual files to be uploaded will "usually" be PDF files, Excel files, and Word Documents.)
And I am hoping this can be done with Excel VBA.
I keep getting error 91 - object variable or with block variable not set
If this is not possible please advise. If I could call a C# or VB.NET routine to finish this task then I would need a config file where I supply the URL, username, and password.
I can not give anyone access to the acyual site as it is company private.