Opening Word doc from Excel VB - and adding page numbers

I have managed to create code to create a new word doc, open the doc and insert text into the word doc header and footer; But I can't find a way to get a 'Page x of y' into the footer; The code that is generated by recording a macro in word to do this fails when that code is placed inside the excel code. Any ideas??

Both;

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Both these seem to fail when the code is in Excel rather than in word?? Help??