Export Excel Ranges to Word bookmarks using VBA

Hi everyone,

I am using MS Excel 2007 and MS Word 2007. I have a workbook with a number of named cells. I have a word document named with a number of bookmarks. The names in excel match the bookmarks in word. I need to export the values in the excel named cells to populate the bookmarks in the word document and then save the word document as a new file with a name based on the values of one of the bookmarks.

The name/location of the excel workbook will always be different whereas the name/location of the word document will not change.

Some of the names/bookmarks need to be formatted in a specific manner e.g. the date need to be in the "dd mmmm yyyy" format, while dollar values need to be "$#,##0".

I'm very new to VBA so dont really know where to go from here, so any help would be most appreciated!