Excel Chart after paste to MS Word 2000 (URGENT)
 

Hi,

I wrote the following code to paste a resized Excel chart into an MS
Word table. In Office 2003, it pastes in Word with the size that I made
it in Excel.

In Office 2000 however, it does not. It seems to revert to the orginal
size. In Excel 2000 it is respecting my resize of the charts.

Here is the paste code.....any suggestions please to make it look the
same in Office 2000

Word.Application.ActiveWindow.ActivePane.Document. Tables.Item(1).Cell(1,
jjj + 1).Range.PasteSpecial(Link:=False, DataType:=3, _
Placement:=0, DisplayAsIcon:=False)

Excel Chart after paste to MS Word 2000 (URGENT)
 

resize it



"scorpion53061" wrote in message
ps.com...
Hi,

I wrote the following code to paste a resized Excel chart into an MS
Word table. In Office 2003, it pastes in Word with the size that I made
it in Excel.

In Office 2000 however, it does not. It seems to revert to the orginal
size. In Excel 2000 it is respecting my resize of the charts.

Here is the paste code.....any suggestions please to make it look the
same in Office 2000

Word.Application.ActiveWindow.ActivePane.Document. Tables.Item(1).Cell(1,
jjj + 1).Range.PasteSpecial(Link:=False, DataType:=3, _
Placement:=0, DisplayAsIcon:=False)

Excel Chart after paste to MS Word 2000 (URGENT)
 

I did resize it in Excel.

I found after using the copypicture method the problem was solved in
Word 2000.

Thanks.

Jezebel wrote:
resize it



"scorpion53061" wrote in message
ps.com...
Hi,

I wrote the following code to paste a resized Excel chart into an MS
Word table. In Office 2003, it pastes in Word with the size that I made
it in Excel.

In Office 2000 however, it does not. It seems to revert to the orginal
size. In Excel 2000 it is respecting my resize of the charts.

Here is the paste code.....any suggestions please to make it look the
same in Office 2000

Word.Application.ActiveWindow.ActivePane.Document. Tables.Item(1).Cell(1,
jjj + 1).Range.PasteSpecial(Link:=False, DataType:=3, _
Placement:=0, DisplayAsIcon:=False)