| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.vba,microsoft.public.word.vba.general
|
|||
|
|||
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% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
| Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
| Import cells from excel into word and create multiple word docs | Excel Programming | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
| Printing Word Document using Excel Programming hangs Word | Excel Programming | |||
Threaded Mode
