Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Eggtavius Eggtavius is offline
external usenet poster
 
Posts: 2
Default VB to show a form for users to enter an address for a template

I work for a large company with many branches around the country.

We want each branch to have access to a range of document templates. The
idea is when a user downloads and opens template, the first thing they have
to do is select from a list that pops up confirming which branch they are
from.

The template will then automatically poulate the template page one header
with the relevant branch address, phone and facsimile details.

I normally do this type of stuff in Excel but this is the first time using
VB and Macros in word.

Any pointers??
--
Many Thanks
EGGcel
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jezebel Jezebel is offline
external usenet poster
 
Posts: 1,384
Default VB to show a form for users to enter an address for a template

1. Work with custom document properties. Define a custom property for each
of the values you're interested in -- branch name, address, phone, etc. If
these are defined in a template, they are inherited by documents created
from the template. Use DocProperty fields to display the values in the
document.

2. Consider a no-macro approach: when you send out a template, insert dummy
values like '[branch name]', '[phone number]', etc. It's obvious to the user
that they have to do something about it; and it's not too hard to teach
people to open the template itself and use File Properties Custom.

3. If you want to automate it, write a macro that runs when a new document
is created, checks if the properties have ever been set and if not displays
a UserForm to edit and save. Rather than putting the macro in every
template, put it in an add-in. If you take this approach you'll also need to
provide a way for users to get back to it when their phone number changes.
And be aware that this sort of exercise is hell on wheels to support.





"Eggtavius" wrote in message
...
I work for a large company with many branches around the country.

We want each branch to have access to a range of document templates. The
idea is when a user downloads and opens template, the first thing they
have
to do is select from a list that pops up confirming which branch they are
from.

The template will then automatically poulate the template page one header
with the relevant branch address, phone and facsimile details.

I normally do this type of stuff in Excel but this is the first time using
VB and Macros in word.

Any pointers??
--
Many Thanks
EGGcel



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to disable the Enter key in a Word template Form Fi daveocampo Page Layout 13 January 6th 11 08:51 PM
Hyperlink to bring up a template form EdYoung111 Microsoft Word Help 1 December 2nd 05 08:08 PM
How can I fill in a form field and have it show up in another FF? Forrest Microsoft Word Help 1 October 21st 05 02:46 PM
Word crashing upon re-use of a template jenwren Microsoft Word Help 5 August 24th 05 11:59 PM
How do I get changes made to a Word template to show on a email Tyler Microsoft Word Help 1 December 31st 04 03:01 AM


All times are GMT +1. The time now is 07:33 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"