ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel into Word (https://www.excelbanter.com/excel-programming/360589-excel-into-word.html)

EA

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

Set MyShape = MyRange.InlineShapes.AddOLEObject(ClassType:="Exce l.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%




All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com