How to put value into SharePoint 2010 metadata lokkup column from VBA (Dokument_New)? RRS feed

  • Question

  • We have a document library With several metadata columns. Some columns are lookup from other SP lists. When creating a new document, we start with a template (from the SP Library drop-down list). The template opens av dialog for the user to enter initial information. Based on this information we want to populate metadata.

    From the VBA code I use ActiveDocument.ContentTypeProperties.Item("Sak").Value = to set values. This Works fine for columns defined as "Single line of text", but I have problems with columns defined as "choise" or "look up".

    When populating libraries for PowerShell I search the look-up liste for the aktual entry and puts the ID of this element into the look-up Field in the Library. How to do this from VBA in the template?

    Thursday, December 12, 2013 7:46 AM