line spacing incorrect when copying to word 2010

[tryer]

Hi, I've posted a similar request before but not been able to sort this problem out probably because I hadn't explained the problem well enough.
I have some code which generates invoices by populating cells in excel then copies the excel worksheet into a word document, when running it generates dozens of invoices at a time.
It runs fine in office 2003 but since converting to office 2010 the line spacing on the word document is double spaced (or maybe more) which is clearly incorrect.
I cannot post the whole workbook as it contains sensitive information so I have created a stripped down version attached which will run and generate a single test invoice to illustrate the problem.
Can anyone who is running office 2010 help to modify the code to correct this error or point me in the right direction to change the word line spacing.

Code within the workbook is:

Please Login or Register  to view this content.

[tryer]

I have been trying to solve this (unsucessfully) by recording a macro in word which has the code below, unfortunately it falls down on the first line

Please Login or Register  to view this content.

[Norie]

Tryer

I looked at your code but I couldn't see the problem.

That's probably because I don't know what the Word document should look like, where the spacing is wrong etc.

[tryer]

Hi Norie,

Thanks for the answer. The problem is on the word docu,ment the line spacing appears double spaced which spreads a single page over two. After much experimenting I have found a possible cause and a workaround solution. Apparently in office 2007 onwards microsoft changed the default line spacing for new documents. I have found that by changing the default style in word to 2003 all works OK. It's not really the best solution as it would be better for the code to be able change the line spacing as it creates the documents but in the absence of any other solution at least it works.

[Norie]

Have you considered using a template rather than starting with a blank document?

It could be setup to have the required line spacing and anything else that might be useful.

Perhaps even a form/ table so you can put the data in the right place.