Thread: Excel into Word
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.word.vba,microsoft.public.word.vba.general
EA EA is offline
external usenet poster
 
Posts: 28
Default 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%