Friday, September 25, 2009

Mark Iwaszko's technical blog: Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive

There is an issue with binding the named ranges in a spreadsheet with the metadata on the server. Adding some VBA script can overcome this.

Sub SetServerProperties()
Dim WB As Workbook
Set WB = ThisWorkbook
For Each Prop In WB.ContentTypeProperties
If Prop.Name = "Project Lead Finance" Then
Prop.Value = Range("A1").Value
End If
Next Prop
End Sub

Mark Iwaszko's technical blog: Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive

1 comment:

Anonymous said...

I recently came across your post and have been reading along. I thought I would leave my first comment. I don't know what to say except that it caught my interest and you've provided informative points. I will visit this blog often.

Thank you,

Business Cash Advance