How do I code bookmark globally for different template?

Yong Xiang · #9 12-19-2018, 08:13 PM

What I'm doing is when I open a new word document, I insert a template which I bookmarked using the code below and it works. Only the First template works but when I open the other few templates to reference from the First template it won't work

Basically, I want to link all dates, location, address to be the same in every page of a few different templates.

Userform Code:

PHP Code:


			
Private Sub CancelBut_Click()

QPMTesting.Hide



'Close the Userform



End Sub





Private Sub OKbut_Click()

    Dim Address As Range

    Dim Location As Range

    Dim HT_Type As Range

    Dim Time As Range

    Dim Weather As Range

    Dim TestDate As Range

    

'Declaration

    

    Set Address = ActiveDocument.Bookmarks("Customer").Range

    Set Location = ActiveDocument.Bookmarks("HT_Location").Range

    Set HT_Type = ActiveDocument.Bookmarks("HT_Type").Range

    Set Time = ActiveDocument.Bookmarks("HT_Install_Date").Range

    Set Weather = ActiveDocument.Bookmarks("Weather").Range

    Set TestDate = ActiveDocument.Bookmarks("Date").Range



'Set declaration as an active bookmark



    Address.Text = Me.TextBox1.Text

    Location.Text = Me.TextBox2.Text

    HT_Type.Text = Me.TextBox3.Text

    Time.Text = Me.TextBox4.Value

    Weather.Text = Me.TextBox5.Text

    TestDate.Text = Me.TextBox6.Value

    

'Set the text to be text or value

    

    Address.Font.AllCaps = True

    Location.Font.AllCaps = True

    HT_Type.Font.AllCaps = True

    Weather.Font.AllCaps = True



'Set Caps for all



    Me.Repaint



'Refresh



    QPMTesting.Hide



'Close the Userform

    

End Sub





Private Sub UserForm_Click()



End Sub

Document Code:

PHP Code:


			
Private Sub Document_Open()

    QPMTesting.Show

End Sub

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
Field Code: Show a value only if bookmark is not empty	Cosmo	Word	7	08-24-2018 01:46 PM
VBA Code to Access Building Block Template in Word 2013 Startup folder	rdross51	Word VBA	2	06-01-2016 07:05 PM
Find Bookmark, move to bookmark, execute code, repeat	raymm3852	Word VBA	10	04-15-2016 06:21 PM
VBA Code in template does not run in new document	highrise955	Word VBA	4	03-06-2016 04:48 PM
Visual basic code for Word 2003 template	KateAus	Word VBA	4	09-09-2012 08:40 PM