Hi Guys,

I'm new here and although I am pretty experienced with VBA for Excel and Access I'm a noob when it comes to Word!

I have a userform that auto-populates a template with content e.g name and address, date, subject, letter body, signature etc. The user form has multiple tabs for gathering all the required information prior to inserting it in the document. No problem with that.

However, we have different branches and departments each of which has their own letterhead with custom header and footer, which I have as separate templates.

What I need to be able to do is to load one of the templates for VBA to populate, based on the selections (from combo's) that the user has made in the userform.

The specific issue for me is, how do you open another document and make it editable to VBA, while keeping the userform active?

I would be most grateful for any help on this.

Thanks
Alan