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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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