Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using userform to add data to multiple word documents

Status
Not open for further replies.

SteIT

Programmer
Nov 22, 2007
18
GB
I have a number of word documents which are updated with data (company name,dates etc.) and then saved as a copy of the original.

I am looking for the best method to prompt user for the date, then open each word document, populate the required fields (using bookmarks) and save a copy.
I have created a userform to collect the data, but now need to open each word document and populate the required fields(bookmarks). Any ideas on how this can be done in vba.

 
Any ideas on how this can be done in vba
Research "Word Automation" or "Word OLE automation".

 

Welcome to Tek-Tips. Please read faq222-2244 to get the best from these forums. It will, amongst other things, guide you to post in the most appropriate forum for your question. In this case VBA questions and answers belong in forum707

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top