How do I code bookmark globally for different template?

Yong Xiang · #3 12-13-2018, 08:43 PM

Thanks, I'm still new to VBA didn't know that I can set a hardcoded constant like this.
I have tried your code but there is one error saying that couldn't find my file? Runtime error '5174'
at Selection.InsertFile FileName:=sPath & sFile, ConfirmConversions:=False,

code :

PHP Code:


			
Function InsertAFile(sFile As String)
  Dim sPath as String
  sPath = "C:\Users\YongX\Desktop\"
  Selection.InsertFile FileName:=sPath & sFile, ConfirmConversions:=False, 
  Link:=False, Attachment:=False
  Selection.TypeBackspace
End Function

Sub Add_HT_PD()
  InsertAFile "HT PD.docx"
End Sub

Sub Add_HT_US()
  InsertAFile "HT US.docx"
End Sub

Sub Add_TF_PD()
  InsertAFile "TF PD.docx"
End Sub

Sub Add_TF_US()
  InsertAFile "TF US.docx"
End Sub

Sub Add_HT()
  InsertAFile "HT.docx"
End Sub

Sub Add_LT()
  InsertAFile "LT.docx"
End Sub

Sub Update_Fields()
  Application.ScreenUpdating = False
  ActiveDocument.PrintPreview
  ActiveDocument.ClosePrintPreview
  Application.ScreenUpdating = True
End Sub

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