Avatar of mgmhicks
mgmhicks
 asked on

Creating Macros for Microsoft Word

I use a program that will let us merge data from the program to a word document.  Then the document is automatically saved in pdf form with in the program.  The problem is that the save form is the information that is on the form before it is brought up and we end up making changes to it.  Problem is then we need to save the letter and then import it, cause again when it auto imports it imports the information before changes.  A work around is to have the document answer a few questions, like a comment, that can be filled in before the document actually opens, thus saving the document automatically with the saved inputted information.  

So my question becomes, (See sample document) how can I with vbscript and word, have it ask for the choices before loading document, then have it filled in on the document.  In sample document I would need to know what needs to be checked and then enter a comment before the document actually loads.  Hope this is understandable.
 CL-NH-LEASE-VIOLATION-NOTICE.doc
Visual Basic ClassicMicrosoft WordVisual Basic.NET

Avatar of undefined
Last Comment
GrahamSkan

8/22/2022 - Mon
GrahamSkan

It is a little difficult to understand the scenario here. I think that we would need more explanation.

Here are a few points:

If the document is already a PDF, you would need to convert it back to a Word document if you want Word to edit it.

The document that you posted is not built for easy data entry. It looks designed for manual entry on to paper.

It would probably be better to use VBA rather than VBScript.

Here is a forms document that can be filled in. It is protected (without a password) to demonstrate its use.
LeaseViolation.doc
mgmhicks

ASKER
ok, so what happens is I put this document into our software package, when it loads it automatically saves it to a database with my software package.  With the document you just sent me it would save a blank document (nothing filled in once it loads.)  But If I can get Word throught ASK Field or something like that, to ask me what needs to be checked before it loads completely, the program will then save the document with answers filled in.  Does that help.  So I know I can build a macro or something that would ask the questions upon load, but how to get answers filled into the form you just filled or similiar is the question.

thanks
GrahamSkan

Outside You might like to try using Fill-In fields. Place each one where you need the text to appear, and make the prompt appropriate.
Your help has saved me hundreds of hours of internet surfing.
fblack61
GrahamSkan

I don't know where the word 'Outside' came from. Ignore it, please.
mgmhicks

ASKER
Can we write a little vb routine, that will load a window with lets say button control and have the answers there corespond to answers we need on the document.  Fill the answers and comment for that matter, then finish load of document with the answers?

ASKER CERTIFIED SOLUTION
GrahamSkan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.