OLEFormat.PreserveFormattingOnUpdate Property (Word)

True preserves formatting done in Microsoft Word to a linked OLE object, such as a table linked to a Microsoft Excel spreadsheet. Read/write Boolean .


expression. PreserveFormattingOnUpdate

expression A variable that represents a 'OLEFormat' object.


When PreserveFormattingOnUpdate is set to True , formatting changes made to the object in Word is preserved when the object is updated. Word updates only the content in the linked object.


This example preserves the formatting of the first shape in the current document, assuming the first shape in the document is a linked OLE object.

Sub PreserveFmtg() 
 ActiveDocument.Shapes(1).OLEFormat _ 
 .PreserveFormattingOnUpdate = True 
End Sub

See also

OLEFormat Object