Edit

OLEFormat.PreserveFormattingOnUpdate property (Word)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.