Controlling Word Footers from Excel

[tk19]

I have a spreadsheet that needs to create a document in Word. Certain items in the word document are different depending on what the user input into the spreadsheet program. I have successfully used commands like .TypeText to insert text, .ParagraphFormat.TextAlignment for full justification, and .ParagraphFormat.LeftIndent to set tab stops. But I just can't figure out how to change the footers in the document. My current solution is to have a separate word document (behaves more like a template) for each footer I need - and all it has is the footer. Then I open the particular document I need and fill in the language. But as it turns out, I'm going to need to handle hundreds of different footers, so I'd need to create hundreds of word documents, which would be a big pain.

Thanks in advance for your help.