Re: Word 2007: Getting a Content Control to lookup the Document Revision metadata field [Word 2007: Getting a Content Control to lookup the Document Revision metadata field]

SimonJ — Fri, 12 Oct 2007 06:20:41 GMT

It took me a while to get round to this but I think I've finally cracked it. Let me know if you have any problems with it.

Simon Jones
Contributing Editor
PC Pro Magazine

Option Explicit

Public Sub UpdateAllFields()
    Dim objStory As Range
    Dim objShape As Shape
    Dim objTOC As TableOfContents
    Dim objTOA As TableOfAuthorities
    Dim objTOF As TableOfFigures

    Application.ScreenUpdating = False
    Application.DisplayAlerts = wdAlertsNone

    For Each objStory In ActiveDocument.StoryRanges
        objStory.Fields.Update

        For Each objShape In objStory.ShapeRange
            UpdateFieldsInShape objShape
        Next

        While Not (objStory.NextStoryRange Is Nothing)
            Set objStory = objStory.NextStoryRange
            objStory.Fields.Update

            For Each objShape In objStory.ShapeRange
                UpdateFieldsInShape objShape
            Next

        Wend

    Next

    For Each objTOC In ActiveDocument.TablesOfContents
        objTOC.Update
    Next

    For Each objTOA In ActiveDocument.TablesOfAuthorities
        objTOA.Update
    Next

    For Each objTOF In ActiveDocument.TablesOfFigures
        objTOF.Update
    Next

Application.DisplayAlerts = wdAlertsAll
Application.ScreenUpdating = True
End Sub

Private Sub UpdateFieldsInShape(iobjShape As Shape)

    With iobjShape.TextFrame

        If .HasText Then
            .TextRange.Fields.Update
        End If

    End With

End Sub

in reply to Word 2007: Getting a Content Control to lookup the Document Revision metadata field

VS 2005 Windows Forms <-> SharePoint [VS 2005 Windows Forms <-> SharePoint]

SimonJ — Thu, 31 Aug 2006 15:57:35 GMT

I'm currently designing a Windows Forms application using Visual Studio 2005 (VB.NET) and SQL Server.

When the user encounters an error or has a problem, I'd like them to be able to raise an issue in an issue tracking database which already exists in SharePoint Services. I could just navigate to the create new form URL on the SharePoint site in a browser window but it would be nice to be able to populate fields with data we already know (Application Name, Version, Form Name, Error message, etc).

Has anyone had any experience doing this?

Alternatively...
Can I convince VS2005 to use SharePoint as a Data Source and so use ADO.NET?

I've looked at the Web Services interface for SharePoint and it looks quite fiendish to someone who doesn't delve into XML unless he really has to.

SimonJ

in reply to VS 2005 Windows Forms <-> SharePoint

Entries for SimonJ

Re: Word 2007: Getting a Content Control to lookup the Document Revision metadata field [Word 2007: Getting a Content Control to lookup the Document Revision metadata field]

VS 2005 Windows Forms <-> SharePoint [VS 2005 Windows Forms <-> SharePoint]