Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    East Lothian, Scotland
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Template Automation (Word 2000)

    Hi there

    I enclose a document template where I want to automate the input of fields when opening up this new template. What I mean is that the user will automatically be taken to the first field i.e. the To: field, on return will be taken to the next field i.e Company field,and so on. I have seen this done by using the Fill-In() parameter but I would like to be able to do it without that window appearing. I would also like to ensure that when saving the document the user is presented with the Save As window so that changes cannot be made to the original template.

    Thanks in advance

    Billy Low
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Wisconsin, USA
    Posts
    193
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Template Automation (Word 2000)

    Billy:

    I have set up your template 2 different ways. The first one is with form text fields with document being protected allowing you to tab through to fill in desired information. The second is more automated that when document is opened, it will prompt you for information which is then filled in wherever referenced. I wasn't sure where exactly you wanted text to be inserted so if you want the text to show up under the message header label, select gray-shaded box, cut it, and paste it to where you want it. Don't cut one field and paste to many different spots and each text field is referencing a different thing.

    Take a look and see if this is what you are looking for. Detach them both to where your templates are located and use "File, New" to see how they work.
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    East Lothian, Scotland
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Template Automation (Word 2000)

    Leanne

    Wonderful. Just what was required. What I now need to know is how this is achieved. Is there a section in any of Woody's books that refer to these techniques or is ti something that can be picked up by trial and error. I have never used VBA, which is what I assume the input grid was designed by.

    Thanks

    Billy

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Wisconsin, USA
    Posts
    193
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Template Automation (Word 2000)

    Billy:

    I learned this from 1-day training. I'm not sure if it is covered in Woody's books or not. About the grid, I'm not sure where that came from and as you can see, I couldn't get it in the 2nd template.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Template Automation (Word 2000)

    The 'input grid' you refer to is called a 'user form' and you create it in the VBE (Visual Basic Editor); look up creating these if you like (you should find them in any Word manual that covers programming in VBA as well), but they are fairly advanced stuff and not for the fainthearted!

    HTH
    Beryl M


  6. #6
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Template Automation (Word 2000)

    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •