Article ID: 182676
Article Last Modified on 6/17/2005
Sub ResetOleShape()
' Create variables.
Dim sOriginalHeight, sOriginalWidth As Integer
' Add a new blank document.
Documents.Add
ActiveDocument.Content.Collapse wdStart
' Create the document object.
Set oInlineShape = ActiveDocument.InlineShapes.AddOLEObject _
(Range:=ActiveDocument.Content, DisplayAsIcon:=False, _
ClassType:="Word.Document.8", LinkToFile:=False)
' Add text to embedded document.
ActiveDocument.Content.InsertAfter "Text in Embedded Document."
' Close out of embedded document return to source document.
ActiveDocument.Close
' Store the original object size.
sOriginalHeight = ActiveDocument.InlineShapes(1).Height
sOriginalWidth = ActiveDocument.InlineShapes(1).Width
' Scale the object to a different size(for testing.)
ActiveDocument.InlineShapes(1).Height = 100
ActiveDocument.InlineShapes(1).Width = 100
' Reset the object to it's original size.
MsgBox "OLE object has been resized. Click OK to reset."
ActiveDocument.InlineShapes(1).Height = sOriginalHeight
ActiveDocument.InlineShapes(1).Width = sOriginalWidth
End Sub
181058 OFF98: How to Run Sample Code from Knowledge Base Articles
163435 VBA: Programming Resources for Visual Basic for Applications
Additional query words: wordcon vb vba vbe
Keywords: kbbug kbmacroexample kbdtacode kbpending KB182676