Hi all,



I am working on creating a report template which can be applied to a number of different "sites". I would like to run a Macro on template start which prompts the user to enter the site name. the macro would look like this:

Private Sub Workbook_Open()
InputBox ("Enter site name")
End Sub

I would like to write this site name into a field which I can place throughout the body of the document (sort of like a cell or name reference in excel).

Can anyone help me with the additional code required and the creation of a custom field from this code?

Alternatively, if there's an easier way to do this I'd love to hear it.

Many thanks!

One option you could choose is to have your Site Name as a FILL IN field, select this field and and set a bookmark. Then use the REF field to include the bookmark.

Use Control + A to select the document and Alt + F9 to update all the fields.

When you create a new document from your template it will bring up the FILL IN Field dialog box.

Thanks Juju, that's exactly what i had in mind. my problem is that i don't know how to take the user input into the pop-up box and write it to the FILL IN field using code.

Example of Document attached, you will need to save it as a template

Attached Files

Report for Site Name.doc (56.5 KB, 15 views)