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.

prompts for a bunch of header information ? can u elaborate ? you mean list of files or what — Bek Raupov, Apr 11 '11 at 14:22
no i just mean the user types in their name and a part name, part number, etc, etc, into a form, then when they click submit it makes the header of the documents have all that info. — mark, Apr 11 '11 at 14:47

score 1 · Accepted Answer · answered Apr 11 '11 at 14:25

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

answered Apr 11 '11 at 14:25

Bek Raupov

3,782
3
24
42

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

1 Answers1