Header and Footer from Excel to Word

[kittu55]

Hi all,

Can someone help me with the code to get the header and footer from Excel to Word.

On the left, The values from cells from A1 and B1 should be on the 1st line and values from cells A2 and B2 should be in the 2nd line.
In footer page numbers should be in the middle.

I have the code to get the header in Excel but i'm not able to transfer it to word.

Can somebody help me

Thanks in Advance

Regards
Kittu

[kittu55]

Can some one help on this plz.