J
Jamie Carper
Problem
When using VBA to copy and paste special ( an Excel image to Word, if the
"White Space" option is turned OFF, the image is rendered out of alignment
with the text.
Conditions
.PasteSpecial DataType:=wdPasteMetafilePicture
.ShapeRange.ScaleWidth 0.54, msoCTrue, msoScaleFromTopLeft
.ShapeRange.ScaleHeight 0.54, msoCTrue, msoScaleFromTopLeft
.ShapeRange.WrapFormat.Type = wdWrapSquare
Solution
Programatically set White Space option ON prior to paste.
(or check the box for Tools\Options\View\White Space Between Pages)
Note: This problem does not show up under similar testing conditions in Word
2002.
When using VBA to copy and paste special ( an Excel image to Word, if the
"White Space" option is turned OFF, the image is rendered out of alignment
with the text.
Conditions
.PasteSpecial DataType:=wdPasteMetafilePicture
.ShapeRange.ScaleWidth 0.54, msoCTrue, msoScaleFromTopLeft
.ShapeRange.ScaleHeight 0.54, msoCTrue, msoScaleFromTopLeft
.ShapeRange.WrapFormat.Type = wdWrapSquare
Solution
Programatically set White Space option ON prior to paste.
(or check the box for Tools\Options\View\White Space Between Pages)
Note: This problem does not show up under similar testing conditions in Word
2002.