View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Open Word Template

Why not go to word and turn on the macro recorder, then execute the action
you want and turn it off. Look at the recorded code to see how Word sets up
the command.

--
Regards,
Tom Ogilvy

"TAM" wrote in message
.uk...
Within Excel I am trying to open a new document from a Word template file
but the template file itself keeps opening. Can you please advise how to
open a document from the template - my code is as follows...

Dim wdApp As Word.Application
Set wdApp = New Word.Application
With wdApp
.Documents.Open Filename:="C:\My Documents\Work\Manual

Project\Templates\01
Front Cover.dot"

I have tried this code with the .doc extension but that only results in an
error

Thanks

TAM