Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking

    I have a 2007 word.docm named “Report” that updates data using link fields from an Excel workbook. My question is, is it possible with using VBA to copy “Report.docm”, remove link field but keeping existing or current data from link fields in tack, so that I can save file and not have to worry that data will change when I reopen. I don’t wish to save in PDF because I may have to make minor changes.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could use code like this:

    Code:
    Dim fld As Field
    For Each fld In ActiveDocument.Fields
      If fld.Type = wdFieldLink Then
    	fld.Unlink
      End If
    Next fld

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •