Excel 2007 : Problem while exporting data from excel to word (2007)

I am trying to export some excel data from excel to word ( 2007 ).
It worked perfectly find in 2003.

I am using the following code :

Please Login or Register  to view this content.

As a result the table gets copied but the text is distored
Could it be due to some printing options ? or addins ?


also if I use

Please Login or Register  to view this content.

the table gets copied but it is blank.


Any help would be appreciated.

THanks,
Piyush

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I've added the code tags, but this time only!