Zugriff auf SharePoint mit Windows 7

Windows 7 ist toll. Im Feierabendbier habe ich aber immer wieder klagen gehört, dass der Zugriff aus Office 2007 (Word, Excel) auf SharePoint Document Libraries langsamer sei als unter Vista. Auch Zugriffe über die Explorer View seien langsam.

Die (trivial) Lösung habe ich hier gefunden: Im Internet Explorer muss die automatische Erkennung des Proxy Servers ausgeschaltet werden. Unter Tools –> Internet Options –> Connections –> LAN Settings muss die Option Automatically Detect Settings deaktiviert werden. In einem Netzwerk mit Proxy Server muss diese Option natürlich nicht deaktiviert werden – hier sollte das Performanceproblem aber auch nicht auftreten.

Damit kann aus Word auch unter Windows 7 schnell auf SharePoint Document Libraries zugegriffen werden.

Display SharePoint Metadata in Word 2003

Yes, there are still customers who use Office 2003 in combination with SharePoint 2007...

So i had to find a generic solution do display SharePoint Metadata in Word 2003 templates. I found different solutions to achieve this, but none of them solved all my Problems. The most common Problem ist the update of your Fields at the right time.

Basics / Limitations:

• SharePoint Metadata is mapped into Word 2003 over Document Properties
• Only Fields of Type "Text" can be mapped (If you need to display Values of other Fields than Type Text, you need to add a Textfield to your Content Type and use a Eventhandler to Copy the Value of your desired Field to the Textfield and map this as Doument Property to your Word Template. A common case could be "Version" or Author of a Document, which are OOB no Textfields)
• OOB Document Properties are updated on Print only (This is a Word Option which is set by Default)
  
  How to:
  
• Bind your Word Template to corresponding ContentType of the DocLib
• Add the following Code, which updates the Fields when the Document opens, as Macro (Macro on the current Document, not as Module) to your Word Template:
  
  Private Sub Document_New()
  
  ActiveDocument.Fields.Update
  
  End Sub
  
  Private Sub Document_Open()
  
  ActiveDocument.Fields.Update
  
  Dim oStory As Object
  Dim oToc As Object
  
  'exit if no document is open
  If Documents.Count = 0 Then Exit Sub
  Application.ScreenUpdating = False
  
  For Each oStory In ActiveDocument.StoryRanges
  oStory.Fields.Update 'update fields in all stories
  Next oStory
  
  For Each oToc In ActiveDocument.TablesOfContents
  oToc.Update 'update TOC's
  Next oToc
  
  Application.ScreenUpdating = True
  
  End Sub
  Private Sub Document_Close()
  
  ActiveDocument.Fields.Update
  
  End Sub
  
  Private Sub Document_Sync(ByVal SyncEventType As Office.MsoSyncEventType)
  
  End Sub
  
  This Code updates all Sections of the Document including Header and Footer, not just the Content Section.

Save your Template and create your first Document from this Template, enjoy the Interopability from SharePoint 2007 and Office 2003. ;-)