Newb needing VBA solution to change formatting

derekcentrico · #9 12-06-2016, 05:36 AM

Sadly, I don't know enough about scripting to figure this out.

The only hyperlinks and data referenced as a potential side effect are the bookmarks and cross references that I want to defeat, so whatever I do wouldn't be a negative to anything like that.

I found this online:

Code:

Sub UnlinkBookmarks()
    Dim aFld As Field
        For Each aFld In ActiveDocument.Fields
            If InStr(1, aFld.Code.Text, "LSU_", 1) Then
                'Debug.Print aFld.Code.Text
                aFld.Unlink
            End If
    Next aFld
End Sub

Now I don't care about looking for specific codes.

Anyway, I just stripped down the code to remove the field LSU_ stuff to something like this below to remove any and all cross-references. But, it didn't work. What am I missing to do the removal of the cross-reference while keeping the original data from the bookmark intact at that spot?

Code:

Sub UnlinkBookmarks()
    Dim aFld As Field
        For Each aFld In ActiveDocument.Fields
                aFld.Unlink
            End
    Next aFld
End Sub

Also, just a FYI. I do not have the fields checked to update fields or linked data before printing. The error still occurs.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
newb - search and replace - WILDCARDS - keep original...?	Bansaw	Word	4	09-01-2016 11:16 AM
Backing up importing & exporting ?? I am a newb	Jazz	OneNote	0	01-27-2016 10:18 PM
newb - need help automating catalogue production	Deeper	Office	2	09-09-2015 01:45 AM
Is there a solution to change the recentfilelist programmatically	dherr	Excel Programming	13	12-02-2014 08:31 AM
NEWB to Macros - formatting exports	EC37	Excel Programming	52	06-25-2014 06:26 AM