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

Question

I want the user to open one document that prompts for a bunch 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.

Answer 1

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