Word Templates - Advice for automating long documents

Hello Experts,

I am still planning my office  WordPerfect to Word  migration at work.
Its moving along but i am still doubting my approach to converting some complex templates, leaving me asking this question.

VB User forms or is there a reusable/easier/no code solution?

Folks like message boxes. I don't know why.

I have a lot of users who are used to some automation to help them fill out a form. Moving the curser from place to place with helpful message boxes along the way.

So, I am looking to convert a bunch WordPerfect Templates to MS Word Templates. The templates are pre formatted long documents with variable text.
The user experience in the WordPerfect templates is pretty complex.
They typically start automatically with a series prompts or keyboard merges, they use logic such if/else and for loops as well as y/n to put in dynamic text while take the user from bookmark to bookmark in the document, even allowing the user to type in a paragraph instead of in a little message box or small field.

I recently learned how to make macro enabled templates in Word that open to a user form with fields. My VB user form has a button on the bottom that inserts the values of the form to bookmarks in the document and closes the form.
It works pretty good. I even figured out how to use checkboxes that dynamically insert different building block auto text to a desired bookmark in the doc. So, I know how to use the developer tab in the ribbon enough to be dangerous but I am still learning. Now that I can do it I replicated it for other templates, but at some point, I foresee that I will want to get out of the template business and train secretaries to make temples. I just can't picture secretaries using VB, ever with instructions and sample code. It just feels wrong. hmmmm

But I can't help wonder if there is another or easier way to automate some less complicated documents.

I noticed some interesting features in Words mail merge that I have yet to duplicate in a .dotm template. For example: "Ask" and "Fill In".

Is it possible to create a .dotm that opens the preformated doc that takes users from fill in to fill in?

Your thoughts are much appreciated.
A  Sample "Hello Word" would be even more appreciated.

Thanks Again!

MikeXnaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
It is possible to make a template for a Forms document, where the document itself acts like a form so that only certain places can be filled in.

Form Fields or Content Controls can used as the fill-in places.

Form Fields are slightly simpler to use, easier to program and are compatible with Word 97 to 2003, but the protection method has unwanted restrictions (e.g. no spell-checking) and they are referred-to as 'legacy' in the ribbon.

The protection method (grouping) for the newer Content Controls is less restrictive and they carry their own prompt text.

It is difficult to avoid using VBA if you need some pop-up prompts. Word Fields, such as Ask and Fill-In will work, but lack flexibility, and tend to prompt at unwelcome times.

Here are a couple of comparative examples
CC.docx
Forms.docx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CharlieDeltaCommented:
If you are looking to get out of the template business then I would look at some of the off-the-shelf products that do that:
 - DataPrompter
 - DocuFill

If you want to set something up yourself then my advice is to keep it really simple for the secretaries where they mark each variable in the template with say, square brackets eg [Contact number] and then your generic wizard reads and displays those with text boxes ready for data entry.
0
MikeXnaAuthor Commented:
Thanks guys.
This is great feedback.

Sound like I will likely be in the template biz for a while.
I have been enjoying it so far.

So far VBA in The developer tab has been suiting my needs. I do with my vb user forms where a little more rich looking.
Are the controls in visual studio better?
For example, their does not seem to be a vba date picker for a user form, however, I did find a control on my computer which is 99% of what I want. It just seems to lack the ability to default to today's date.
I also wish my longer vb form fields supported controls to format the text, add hyperlinks? Etc.
In the meantime, I guess users could add them after they fill out the form and edit the doc.

Word seems to refer to the controls in vb as legacy which concerns me some, but so far I do not a better built in solution without using a 3rd party addin.

@charlie, that is good advice to offer the secretaries. I do not have a "wizard" yet. I have been coding manually in vba.
Did you have a partular wizard in mind?

Thanks!
0
GrahamSkanRetiredCommented:
There is a Calendar control that ships with Access, so you might have that. However I wouldn't recommend it without having a separate textbox to display the return vale date because it isn't obvious if it has been updated since a different year or month has been selected.

0
CharlieDeltaCommented:
By Wizard I just mean a VBA form or VBA dialog - whatever is best to call them.

That idea is just a simple generic data entry tool where the dialog looks for occurrences of the variables in the document eg  [Contact name] and then offers those in the dialog with a text box for each.

There are a huge number of additional controls you can use in your VBA as you know, (eg date pickers, Rich text boxes, etc) both built in and 3rd party, but I try to avoid them if possible as reliability dips the more external functions you use. ie things that work on your machine dont always work on others and it starts to get version dependent.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Suites-Other

From novice to tech pro — start learning today.