http://support.microsoft.com/support.../Q123/8/59.asp
ACC: Sample OLE Automation for MS Word and MS Excel

http://support.microsoft.com/support...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic

http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/default...83&Product=xlw
How to Create a Form Letter with a Visual Basic Macro

http://support.microsoft.com/default...16&Product=xlw
XL2000: Macro to Link a Range of Cells in Word

http://support.microsoft.com/default...74&Product=xlw
OFF: How to Use (OLE) Automation with Word

--
Regards,
Tom Ogilvy


"Roel" wrote in message
...
This must be quite a routine job but I haven't found a
good example anywhere.
I have an Excel worksheet containing data that will be
exported to a Word document which in fact is a form. My
VBA-program should open the Word document, export the
data to the correct locations in the form, save the form
under a new filename and close the Word documents.
Any examples coming close to solving this problem?
Thanks,
Roel