Open word template file

[dirtychinchilla]

Morning all,

I'm having some trouble with trying to get a template file to open from an excel link.

I have a word document template, which is basically a blank quote sheet. I want this document to open, but if I use a hyperlink it doesn't create a copy like a template normally would, but you end up editing the actual template.

So, I think that I need a macro here, but am really clueless as to what to do. I've had a good search but have just been confused, so any help would be much appreciated.

Thanks in advance,

dirtychinchilla

 

[dirtychinchilla]

You are indeed getting somewhere, weird behaviour though! Would it be possible for you to give me code for saving as a new name?

Thanks so much for your help

 

[bewsh1987]

that just because am new at this forum thing need to get the experience.


try the below

Private Sub CommandButton1_Click()
'existing file as New template
Set word = CreateObject("word.Application")
word.Documents.Add Template:= _
        "S:\Cosmetics Merchandise Planning\Ian\SQL Queries.doc", _
        NewTemplate:=True, DocumentType:=0
With word
.Visible = True
.ActiveDocument.SaveAs2 Filename:="C:\Users\" & "Name" & " " & Format(Date, "ddmmyyyy") & ".doc"  'you may want to change this
End With
End Sub

no problem at all

 

[dirtychinchilla]

I mean weird behaviour for excel, not you!! Haha!

Thanks very much for that, all is well in the world again. Enjoy the forum, it's excellent