How do i make one form in a word document open multiple other documents and fill out identicall headers in word / excel?

I want the user to open one document that prompts for a bunch开发者_Python百科 of header information, then once the user presses a button, it opens other selected word docs and excel spreadsheets (if possible) then saves and closes them.

you can use Workbooks.Open(Filename:="C:\test.xls")

and then do ActiveWorkbook.Save and .Close accodingly

note you can work on one workbook at a time