vba - How do i make one form in a word document open multiple other documents and fill out identicall headers in word / excel? -
i want user open 1 document prompts bunch of header information, once user presses button, opens other selected word docs , excel spreadsheets (if possible) saves , closes them.
you can use workbooks.open(filename:="c:\test.xls")
and activeworkbook.save , .close accodingly
note can work on 1 workbook @ time
Comments
Post a Comment