A good VBA reference would be Excel Power Programming by John Walkenbach.

Using the mail merge interaction of Word and Excel is one way to do what you want, making multiple copies of a document, one per row if data in Excel. See
http://word.mvps.org/FAQS/MailMerge/...AMailMerge.htm
http://www.mvps.org/dmcritchie/excel/mailmerg.htm (and links at the end of the page)
http://office.microsoft.com/en-us/ex...037601033.aspx
http://j-walk.com/ss/excel/tips/tip92.htm

You could use the bit of code I provided before to allow reuse of the bookmarks, or you could just close the Word document and reopen it to get a fresh copy. Or make a template, and create a new file based on the template for each row of the Excel worksheet.