Guest
|
 Posted: Thu Dec 20, 2007 7:14 am Post subject: Use Word vba to copy a range from Excel into Word |
 |
|
Hi,
I would like to use Word vba to copy a range from Excel into Word:
'oWB is the open excel worksheet
'Copy the range
oWB.Worksheets("Sheet1").Range("$BZ$3:$CG$77").Copy
'Now paste into word
Selection.Range.PasteAndFormat wdChartPicture
However, this actually pastes as a Table.
I want the excel range to look like it would if you manually:
1) copied it in Excel
2) in Word, Paste special (picture - enhanced metafile)
Any ideas ?
Thanks,
Tom |
|
