![]() |
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