LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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.


.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determine when Word document opens successfully from Excel VBA Alan[_8_] Excel Programming 2 April 14th 09 04:00 AM
editting a template kaja New Users to Excel 2 June 6th 08 10:29 PM
help creating a macro in excel that opens a specific word document Prohock Excel Discussion (Misc queries) 3 March 30th 06 04:58 PM
Macro in template opens last saved document smoenra Excel Programming 2 July 1st 04 01:56 PM
Word document from template Enescu Gabriel Excel Programming 2 April 10th 04 06:15 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"