Excel into Word

E

EA

In Office 2000 the code below inserts the new object with a ScaleHeight =
100% and a ScaleWidth = 100%

Set MyShape = MyRange.InlineShapes.AddOLEObject(ClassType:="Excel.Sheet.8",
_
FileName:=sPATH,
_
LinkToFile:=False,
_
DisplayAsIcon:=False)

When the same code is run on Office 2003 the ScaleHeight = 97% and the
ScaleWidth = 105%.

Can anyone explain this?

Equally importantly, can anyone provide a way of ensuring the import Excel
sheet's ScaleHeight and ScaleWidth = 100%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inlineShape.OLEFormat.Activate() command fails for excel file 0
Launching PowerPoint from an Excel application 2
Changing Fonts and other attributes on a printable slide added by 1
Paste special in VB 1
Copy/Paste Charts; Define Destination of Charts in PowerPoint 2
Error message "object variable or with block varible not set" Help. 3
From access, SCALE picture in Word after using AddPicture method 1
Powerpoint macro inserting pictures 0

Top