none
Macro Code for update fields upon Excel document open RRS feed

  • Question

  •  Macro Code for update fields upon Excel document open. This is used to support Documentum properties synchronization with Office properties.

    The below word code is working as expected. same way we need Excel Macro code. Can you please suggest any one.

    ===========================================

    Sub AutoOpen()
        Dim aStory As Range
        Dim aField As Field
            For Each aStory In ActiveDocument.StoryRanges
            For Each aField In aStory.Fields
                aField.Update
            Next aField
        Next aStory
            ActiveDocument.Saved = True
    End Sub

    =============================================

    Thursday, July 13, 2017 11:59 AM

Answers