Help With Word Template and InputBox

[Kayslover]

I have got a Word Template that uses the several FILLIN field codes that asks the user to enter data and then populates the document with the data entered.

The problem I have is that I would like to use the data entered against each FILLIN field to save the file with a particular standard. But, alas, these field codes cannot be used. I want the document to be saved with the following standard "Invoice No Cust Name Address" and saved to the directory that the template has been opened from.

So I was thinking to use the InputBox method to save the answers of each InputBox and use those.

The question I have is how do I populate things in the document from the InputBox. What I mean is, If I use InputBox to ask for an Invoice No, Cust Name Address, phone number, how can I then update the document to place these values in the appropriate place?

Hope the makes sence.

 

[Macropod]

The problem I have is that I would like to use the data entered against each FILLIN field to save the file with a particular standard. But, alas, these field codes cannot be used.

Why can't the field results be used?

 

[Kayslover]

Macropod,

Firstly, Thank you for taking the time to look at this thread.

I have now decided to use a macro than the FILLIN field codes which are in the Template. As such I am going to using the InputBox method to get data to the macro.

The macro allows me greater flexibility as it will allow me to save the file with pre-determined names.

But the question I asked originally stands:-

How do I populate things in the document from the InputBox. What I mean is, If I use InputBox to ask for an Invoice No, Cust Name Address, phone number, how can I then update the document to place these values in the appropriate place? Also I would also like to save files as a normal Word document with the names as Invoice No, Cust Name and saved to the same place as the Template (I will be opening the template and running the macro from there).

 

[Macropod]

Presumably your InputBox is on a userform, in which case, populating the document can be done in a variety of ways. See:

• Create a Simple Userform by Graham Mayor, MVP
• Create & Employ a Userform by Greg Maxey

 

[Kayslover]

I have no User Forms (as there are training issues), the InputBox is in a macro. It's from the macro that I would like to populate the template and once all fields have been populated, save the file as a normal Word document.

 

[Macropod]

I'd be surprised if a userform brought more training issues with it than a series of inputboxes that disappear once they're completed. Nevertheless, the document population principles are the same as for a userform.

 

[Kayslover]

Macropod,

Thank you for posting the links, I will look at them and progress.