Hello All,

My first post! Hope someone helps!

I currently have a macro in Excel which opens a set of word docs, does some manipulation, saves the doc, closes the doc and then opens a new doc. Everything works fine till this point.

Now, I want to add footer in each word doc (it may have more than 1 page) which is a construct. The footer should be "Some Text" & Pagenumber. Can anyone help me / guide me how to do this using vba? Thanks a lot.