BUG ScaleHieght and ScaleWidth Alway return 0 For Inline Spreadshe

N

NateLake

I believe that there may be a bug in Word 2007 related to the ScaleHeight and
ScaleWidth of an Inline OLE EXCEL spreadsheet. The issue is that the
ScaleWidth and the scale heigh always return 0. Step to reproduce this issue
include

Open Word 2007
Paste any EXCEL spreadsheet an Microsoft Excel Office Worksheet Object
Run the VBA CodeBelow


Sub TestInlineObject()
ActiveDocument.InlineShapes(1).ScaleWidth = 50
MsgBox ActiveDocument.InlineShapes(1).ScaleWidth
End Sub

Expected Results:
The shape width is scaled 50%
MsgBox ActiveDocument.InlineShapes(1).ScaleWidth should return 50

Actual Results:
The shape width is scaled 50%
MsgBox ActiveDocument.InlineShapes(1).ScaleWidth returns 0

THanks,
Nathan Lacoff
 

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

Word 2007 bug: Inlineshapes(1).scale width returns 0 3
Inline ScaleHeight/ScaleWidth returns 0 in Word 2007 1
Word 2007 inlineshape scalewidth property always returns 0 1
Scaling Pictures with VBA 4
Changing Fonts and other attributes on a printable slide added by 1
Macro for Picture size and crop, layout and position in table. 8
macro to copy from excel & jpg files to word doc? 4
Copy/Paste Charts; Define Destination of Charts in PowerPoint 2

Top