US letter using a Word template? in Word General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
alocin 9/27/2005 2:02 PM PST
  Question
  How do I auto-format page setup to US Letter using a Word template?
I want to be able to attach a template to my documents that will change the
page setup from A4 to Letter without me having to go and do this via the page
setup dialog for each document.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Anne Troy 9/27/2005 2:15 PM PST
  Answer
  Record a macro. :)
http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm
Attaching a template won't change the page setup, tho. You need to record
the steps to changing the page setup.
************
Anne Troy
www.OfficeArticles.com

"alocin" <alocin@discussions.microsoft.com> wrote in message
news:10745EB0-32EB-4F60-8194-60750792CD33@microsoft.com...
> How do I auto-format page setup to US Letter using a Word template?
> I want to be able to attach a template to my documents that will change
> the
> page setup from A4 to Letter without me having to go and do this via the
> page
> setup dialog for each document.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
alocin 9/27/2005 2:19 PM PST
   
  Hi anne, thanks for your quick reply!
Can I get the macro to autorun when the template is attached?
Thanks again :o)

"Anne Troy" wrote:

> Record a macro. :)
> http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm
> Attaching a template won't change the page setup, tho. You need to record
> the steps to changing the page setup.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "alocin" <alocin@discussions.microsoft.com> wrote in message
> news:10745EB0-32EB-4F60-8194-60750792CD33@microsoft.com...
> > How do I auto-format page setup to US Letter using a Word template?
> > I want to be able to attach a template to my documents that will change
> > the
> > page setup from A4 to Letter without me having to go and do this via the
> > page
> > setup dialog for each document.
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Herb Tyson [MVP] 9/27/2005 2:36 PM PST
   
  You'd probably want an AutoOpen macro. An AutoOpen macro runs when a
document is opened. The macro would first test to see if the page setup has
already been done, and if not, then make the change. There are a variety of
ways to do this. You might post in one of the VBA groups for additional help
if you hit any stumbling blocks.

Cheers,

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"alocin" <alocin@discussions.microsoft.com> wrote in message
news:58079465-DD68-4F16-B8C4-B2B81F7A36D0@microsoft.com...
> Hi anne, thanks for your quick reply!
> Can I get the macro to autorun when the template is attached?
> Thanks again :o)
>
> "Anne Troy" wrote:
>
>> Record a macro. :)
>> http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm
>> Attaching a template won't change the page setup, tho. You need to record
>> the steps to changing the page setup.
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "alocin" <alocin@discussions.microsoft.com> wrote in message
>> news:10745EB0-32EB-4F60-8194-60750792CD33@microsoft.com...
>> > How do I auto-format page setup to US Letter using a Word template?
>> > I want to be able to attach a template to my documents that will change
>> > the
>> > page setup from A4 to Letter without me having to go and do this via
>> > the
>> > page
>> > setup dialog for each document.
>>
>>
>>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Anne Troy 9/27/2005 2:36 PM PST
   
  I don't think that attaching a template is an event in Word. I'd be inclined
to think this is a question to be asked in the
microsoft.public.word.vba.general newsgroup while you're at it.
************
Anne Troy
www.OfficeArticles.com

"alocin" <alocin@discussions.microsoft.com> wrote in message
news:58079465-DD68-4F16-B8C4-B2B81F7A36D0@microsoft.com...
> Hi anne, thanks for your quick reply!
> Can I get the macro to autorun when the template is attached?
> Thanks again :o)
>
> "Anne Troy" wrote:
>
>> Record a macro. :)
>> http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm
>> Attaching a template won't change the page setup, tho. You need to record
>> the steps to changing the page setup.
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "alocin" <alocin@discussions.microsoft.com> wrote in message
>> news:10745EB0-32EB-4F60-8194-60750792CD33@microsoft.com...
>> > How do I auto-format page setup to US Letter using a Word template?
>> > I want to be able to attach a template to my documents that will change
>> > the
>> > page setup from A4 to Letter without me having to go and do this via
>> > the
>> > page
>> > setup dialog for each document.
>>
>>
>>


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Graham Mayor 9/27/2005 9:02 PM PST
   
  If all you want to do is change the page size of your documents without
using the page setup, then open the document and run the following macro:


Sub USLetterPage()
With ActiveDocument.PageSetup
.PageWidth = CentimetersToPoints(21.59)
.PageHeight = CentimetersToPoints(27.94)
End With
End Sub

http://www.gmayor.com/installing_macro.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

alocin wrote:
> How do I auto-format page setup to US Letter using a Word template?
> I want to be able to attach a template to my documents that will
> change the page setup from A4 to Letter without me having to go and
> do this via the page setup dialog for each document.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies