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 .

Syntax

expression. PreserveFormattingOnUpdate

expression A variable that represents a 'OLEFormat' object.

Remarks

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.

Example

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