Hyperlink to a Word Template

R

rhollo

I am trying to create a hyperlink in Excel to a Word Template. But
want the hyperlink to open a new document of the template instead o
opening the template itself. Can anyone help
 
D

Dave Peterson

Does it have to be a hyperlink?

Maybe you could put a button from the forms toolbar on the worksheet and assign
it a macro to open a new word document based on your template:

Option Explicit
Sub testme01()

Dim oWord As Object
Dim myWordTemplate As String
Dim testStr As String

myWordTemplate = "c:\msoffice\templates\1033\Elegant Fax.dot"

testStr = ""
On Error Resume Next
testStr = Dir(myWordTemplate)
On Error GoTo 0
If testStr = "" Then
MsgBox myWordTemplate & " doesn't exist"
Exit Sub
End If

On Error Resume Next
Set oWord = GetObject(, "Word.Application")
If Err Then
Set oWord = CreateObject("Word.Application")
End If

oWord.Visible = True
oWord.Documents.Add Template:=myWordTemplate

End Sub
 
Top