Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink opens word template for editting, not as new document
I have created hyperlinks to Word documents and templates in Excel. Clicking
the hyperlinks causes the templates to open in Word for editting. I need to have the templates open new documents based on the templates. How can I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink opens word template for editting, not as new document
hi, Neil !
I have created hyperlinks to Word documents and templates in Excel. Clicking the hyperlinks causes the templates to open in Word for editting. I need to have the templates open new documents based on the templates. How can I do this? create shortcuts (.lnk) to the template document and hyperlink to that shortcut see - http://support.microsoft.com/kb/278627 hth, hector. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink opens word template for editting, not as new documen
I've been there, done that, and it didn't work.
If I just type the shortcut name as "Shortcut to Mytemplate.dotm" I get a file not found error. If I type the shortcut name as "Shortcut to Mytemplate.dotm.lnk" it opens the template file for editting, not a new document based on the template. I am using Excel as a menu for 100 users so they don't have to know where the files and templates are kept on the server. "Héctor Miguel" wrote: hi, Neil ! I have created hyperlinks to Word documents and templates in Excel. Clicking the hyperlinks causes the templates to open in Word for editting. I need to have the templates open new documents based on the templates. How can I do this? create shortcuts (.lnk) to the template document and hyperlink to that shortcut see - http://support.microsoft.com/kb/278627 hth, hector. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink opens word template for editting, not as new documen
hi, Neil !
I am using Excel as a menu for 100 users so they don't have to know where the files and templates are kept on the server... perhaps using (protected) code ?... Sub NewDocTemplateBased() With CreateObject("word.application") .Documents.Add _ Template:="Location To Your\Template Name.dot", _ NewTemplate:=False, DocumentType:=0 .Visible = True End With End Sub hth, hector. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink opens word template for editting, not as new documen
I modified your code as follows and put it in a blank document. I then
hyperlinked to the blank document: Sub Document_Open() With CreateObject("word.application") .Documents.Add _ Template:="Location To Your\Template Name.dotm", _ NewTemplate:=False, DocumentType:=0 .Visible = True End With Application.Quit savechanges:=wdDoNotSaveChanges End Sub When the hyperlink opens the blank document, the code opens the template, creating a new document and then closes the first (blank) document, leaving only the desired new document open. Thanks for your help. "Héctor Miguel" wrote: hi, Neil ! I am using Excel as a menu for 100 users so they don't have to know where the files and templates are kept on the server... perhaps using (protected) code ?... Sub NewDocTemplateBased() With CreateObject("word.application") .Documents.Add _ Template:="Location To Your\Template Name.dot", _ NewTemplate:=False, DocumentType:=0 .Visible = True End With End Sub hth, hector. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine when Word document opens successfully from Excel VBA | Excel Programming | |||
editting a template | New Users to Excel | |||
help creating a macro in excel that opens a specific word document | Excel Discussion (Misc queries) | |||
Macro in template opens last saved document | Excel Programming | |||
Word document from template | Excel Programming |