For:
1 - Change 'ThisDocument.Path & "\REPORT.* ~"' to '"C:\invoicedocs\REPORT.* ~"'
2 - You should be saving an empty invoice as a Word template (.dot extension), as per post #6 and, if you change the macro's name to 'Document_New' as suggested in post #6, the macro will run automatically each time you create an new document from the template.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|