Open a word doc from Excel, set footer and close

[excelpunk]

Hello All!

I am currently trying to develop a macro but it involves word docs and hence the problem starts for me

In an excel sheet, in column E (from Row #2), I have complete address of the word docs and in column F, I have some text which I want to set them as right footer for its corresponding word doc.

Can anyone guide me how to develop vba code which would open each word doc, set the right footer, save the doc and close it and loop this process so that all word docs are covered.

Any help regarding this would be greatly appreciated. BTW there seems to be very less info about handing word docs using Excel. That's strange!

Thanks in advance

 

[excelpunk]

Can I Seek divine intervention of MVPs