Rather than trying to generate the footers in both Word and Excel, you may do better to insert the Excel data into Word as a table, then simply use Word's own header/footer settings. Excel really isn't designed with the same kind of header/footer control in mind that you find in Word - Excel is more of an analysis and data reporting tool.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]