Issue with footer in word using vba

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.

For Example: First page footer should read: Rob-1, second page footer should read Rob-2, third page footer should read Rob-3 and so on....

footer pagenumbers are a field in word, try recording a macro in word to add page numbers, then convert the code to work within your existing code