Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2013 > Word 2013 > Welcome to the Word 2013 developer reference > Object model reference (Word 2013 developer reference) > Options Object (Word) > Properties > Options.PasteMergeFromXL Property (Word)
Office and SharePoint development
Office client development
Office 2013
Word 2013
Welcome to the Word 2013 developer reference
Object model reference (Word 2013 developer reference)
Options Object (Word)
Properties
Options.AddBiDirectionalMarksWhenSavingTextFile Property (Word)
Options.AddControlCharacters Property (Word)
Options.AddHebDoubleQuote Property (Word)
Options.AlertIfNotDefault Property (Word)
Options.AllowAccentedUppercase Property (Word)
Options.AllowClickAndTypeMouse Property (Word)
Options.AllowCombinedAuxiliaryForms Property (Word)
Options.AllowCompoundNounProcessing Property (Word)
Options.AllowDragAndDrop Property (Word)
Options.AllowOpenInDraftView Property (Word)
Options.AllowPixelUnits Property (Word)
Options.AllowReadingMode Property (Word)
Options.AnimateScreenMovements Property (Word)
Options.Application Property (Word)
Options.ApplyFarEastFontsToAscii Property (Word)
Options.ArabicMode Property (Word)
Options.ArabicNumeral Property (Word)
Options.AutoCreateNewDrawings Property (Word)
Options.AutoFormatApplyBulletedLists Property (Word)
Options.AutoFormatApplyFirstIndents Property (Word)
Options.AutoFormatApplyHeadings Property (Word)
Options.AutoFormatApplyLists Property (Word)
Options.AutoFormatApplyOtherParas Property (Word)
Options.AutoFormatAsYouTypeApplyBorders Property (Word)
Options.AutoFormatAsYouTypeApplyBulletedLists Property (Word)
Options.AutoFormatAsYouTypeApplyClosings Property (Word)
Options.AutoFormatAsYouTypeApplyDates Property (Word)
Options.AutoFormatAsYouTypeApplyFirstIndents Property (Word)
Options.AutoFormatAsYouTypeApplyHeadings Property (Word)
Options.AutoFormatAsYouTypeApplyNumberedLists Property (Word)
Options.AutoFormatAsYouTypeApplyTables Property (Word)
Options.AutoFormatAsYouTypeAutoLetterWizard Property (Word)
Options.AutoFormatAsYouTypeDefineStyles Property (Word)
Options.AutoFormatAsYouTypeDeleteAutoSpaces Property (Word)
Options.AutoFormatAsYouTypeFormatListItemBeginning Property (Word)
Options.AutoFormatAsYouTypeInsertClosings Property (Word)
Options.AutoFormatAsYouTypeInsertOvers Property (Word)
Options.AutoFormatAsYouTypeMatchParentheses Property (Word)
Options.AutoFormatAsYouTypeReplaceFarEastDashes Property (Word)
Options.AutoFormatAsYouTypeReplaceFractions Property (Word)
Options.AutoFormatAsYouTypeReplaceHyperlinks Property (Word)
Options.AutoFormatAsYouTypeReplaceOrdinals Property (Word)
Options.AutoFormatAsYouTypeReplacePlainTextEmphasis Property (Word)
Options.AutoFormatAsYouTypeReplaceQuotes Property (Word)
Options.AutoFormatAsYouTypeReplaceSymbols Property (Word)
Options.AutoFormatDeleteAutoSpaces Property (Word)
Options.AutoFormatMatchParentheses Property (Word)
Options.AutoFormatPlainTextWordMail Property (Word)
Options.AutoFormatPreserveStyles Property (Word)
Options.AutoFormatReplaceFarEastDashes Property (Word)
Options.AutoFormatReplaceFractions Property (Word)
Options.AutoFormatReplaceHyperlinks Property (Word)
Options.AutoFormatReplaceOrdinals Property (Word)
Options.AutoFormatReplacePlainTextEmphasis Property (Word)
Options.AutoFormatReplaceQuotes Property (Word)
Options.AutoFormatReplaceSymbols Property (Word)
Options.AutoKeyboardSwitching Property (Word)
Options.AutoWordSelection Property (Word)
Options.BackgroundSave Property (Word)
Options.BibliographySort Property (Word)
Options.BibliographyStyle Property (Word)
Options.BrazilReform Property (Word)
Options.ButtonFieldClicks Property (Word)
Options.CheckGrammarAsYouType Property (Word)
Options.CheckGrammarWithSpelling Property (Word)
Options.CheckHangulEndings Property (Word)
Options.CheckSpellingAsYouType Property (Word)
Options.CommentsColor Property (Word)
Options.ConfirmConversions Property (Word)
Options.ContextualSpeller Property (Word)
Options.ConvertHighAnsiToFarEast Property (Word)
Options.CreateBackup Property (Word)
Options.Creator Property (Word)
Options.CtrlClickHyperlinkToOpen Property (Word)
Options.CursorMovement Property (Word)
Options.DefaultBorderColor Property (Word)
Options.DefaultBorderColorIndex Property (Word)
Options.DefaultBorderLineStyle Property (Word)
Options.DefaultBorderLineWidth Property (Word)
Options.DefaultEPostageApp Property (Word)
Options.DefaultFilePath Property (Word)
Options.DefaultHighlightColorIndex Property (Word)
Options.DefaultOpenFormat Property (Word)
Options.DefaultTextEncoding Property (Word)
Options.DefaultTray Property (Word)
Options.DefaultTrayID Property (Word)
Options.DeletedCellColor Property (Word)
Options.DeletedTextColor Property (Word)
Options.DeletedTextMark Property (Word)
Options.DiacriticColorVal Property (Word)
Options.DisableFeaturesbyDefault Property (Word)
Options.DisableFeaturesIntroducedAfterbyDefault Property (Word)
Options.DisplayAlignmentGuides Property (Word)
Options.DisplayGridLines Property (Word)
Options.DisplayPasteOptions Property (Word)
Options.DocumentViewDirection Property (Word)
Options.DoNotPromptForConvert Property (Word)
Options.EnableHangulHanjaRecentOrdering Property (Word)
Options.EnableLegacyIMEMode Property (Word)
Options.EnableLiveDrag Property (Word)
Options.EnableLivePreview Property (Word)
Options.EnableMisusedWordsDictionary Property (Word)
Options.EnableProofingToolsAdvertisement Property (Word)
Options.EnableSound Property (Word)
Options.EnvelopeFeederInstalled Property (Word)
Options.ExpandHeadingsOnOpen Property (Word)
Options.FormatScanning Property (Word)
Options.FrenchReform Property (Word)
Options.GridDistanceHorizontal Property (Word)
Options.GridDistanceVertical Property (Word)
Options.GridOriginHorizontal Property (Word)
Options.GridOriginVertical Property (Word)
Options.HangulHanjaFastConversion Property (Word)
Options.HebrewMode Property (Word)
Options.IgnoreInternetAndFileAddresses Property (Word)
Options.IgnoreMixedDigits Property (Word)
Options.IgnoreUppercase Property (Word)
Options.IMEAutomaticControl Property (Word)
Options.InlineConversion Property (Word)
Options.InsertedCellColor Property (Word)
Options.InsertedTextColor Property (Word)
Options.InsertedTextMark Property (Word)
Options.INSKeyForOvertype Property (Word)
Options.INSKeyForPaste Property (Word)
Options.InterpretHighAnsi Property (Word)
Options.LocalNetworkFile Property (Word)
Options.MapPaperSize Property (Word)
Options.MarginAlignmentGuides Property (Word)
Options.MatchFuzzyAY Property (Word)
Options.MatchFuzzyBV Property (Word)
Options.MatchFuzzyByte Property (Word)
Options.MatchFuzzyCase Property (Word)
Options.MatchFuzzyDash Property (Word)
Options.MatchFuzzyDZ Property (Word)
Options.MatchFuzzyHF Property (Word)
Options.MatchFuzzyHiragana Property (Word)
Options.MatchFuzzyIterationMark Property (Word)
Options.MatchFuzzyKanji Property (Word)
Options.MatchFuzzyKiKu Property (Word)
Options.MatchFuzzyOldKana Property (Word)
Options.MatchFuzzyProlongedSoundMark Property (Word)
Options.MatchFuzzyPunctuation Property (Word)
Options.MatchFuzzySmallKana Property (Word)
Options.MatchFuzzySpace Property (Word)
Options.MatchFuzzyTC Property (Word)
Options.MatchFuzzyZJ Property (Word)
Options.MeasurementUnit Property (Word)
Options.MergedCellColor Property (Word)
Options.MonthNames Property (Word)
Options.MoveFromTextColor Property (Word)
Options.MoveFromTextMark Property (Word)
Options.MoveToTextColor Property (Word)
Options.MoveToTextMark Property (Word)
Options.MultipleWordConversionsMode Property (Word)
Options.OMathAutoBuildUp Property (Word)
Options.OMathCopyLF Property (Word)
Options.OptimizeForWord97byDefault Property (Word)
Options.Overtype Property (Word)
Options.PageAlignmentGuides Property (Word)
Options.Pagination Property (Word)
Options.ParagraphAlignmentGuides Property (Word)
Options.Parent Property (Word)
Options.PasteAdjustParagraphSpacing Property (Word)
Options.PasteAdjustTableFormatting Property (Word)
Options.PasteAdjustWordSpacing Property (Word)
Options.PasteFormatBetweenDocuments Property (Word)
Options.PasteFormatBetweenStyledDocuments Property (Word)
Options.PasteFormatFromExternalSource Property (Word)
Options.PasteFormatWithinDocument Property (Word)
Options.PasteMergeFromPPT Property (Word)
Options.PasteMergeFromXL Property (Word)
Options.PasteMergeLists Property (Word)
Options.PasteOptionKeepBulletsAndNumbers Property (Word)
Options.PasteSmartCutPaste Property (Word)
Options.PasteSmartStyleBehavior Property (Word)
Options.PictureEditor Property (Word)
Options.PictureWrapType Property (Word)
Options.PortugalReform Property (Word)
Options.PrecisePositioning Property (Word)
Options.PreferCloudSaveLocations Property (Word)
Options.PrintBackground Property (Word)
Options.PrintBackgrounds Property (Word)
Options.PrintComments Property (Word)
Options.PrintDraft Property (Word)
Options.PrintDrawingObjects Property (Word)
Options.PrintEvenPagesInAscendingOrder Property (Word)
Options.PrintFieldCodes Property (Word)
Options.PrintHiddenText Property (Word)
Options.PrintOddPagesInAscendingOrder Property (Word)
Options.PrintProperties Property (Word)
Options.PrintReverse Property (Word)
Options.PrintXMLTag Property (Word)
Options.PromptUpdateStyle Property (Word)
Options.RepeatWord Property (Word)
Options.ReplaceSelection Property (Word)
Options.RevisedLinesColor Property (Word)
Options.RevisedLinesMark Property (Word)
Options.RevisedPropertiesColor Property (Word)
Options.RevisedPropertiesMark Property (Word)
Options.RevisionsBalloonPrintOrientation Property (Word)
Options.RTFInClipboard Property (Word)
Options.SaveInterval Property (Word)
Options.SaveNormalPrompt Property (Word)
Options.SavePropertiesPrompt Property (Word)
Options.SendMailAttach Property (Word)
Options.SequenceCheck Property (Word)
Options.ShortMenuNames Property (Word)
Options.ShowControlCharacters Property (Word)
Options.ShowDevTools Property (Word)
Options.ShowDiacritics Property (Word)
Options.ShowFormatError Property (Word)
Options.ShowMarkupOpenSave Property (Word)
Options.ShowMenuFloaties Property (Word)
Options.ShowReadabilityStatistics Property (Word)
Options.ShowSelectionFloaties Property (Word)
Options.SkyDriveSignInOption Property (Word)
Options.SmartCursoring Property (Word)
Options.SmartCutPaste Property (Word)
Options.SmartParaSelection Property (Word)
Options.SnapToGrid Property (Word)
Options.SnapToShapes Property (Word)
Options.SpanishMode Property (Word)
Options.SplitCellColor Property (Word)
Options.StoreRSIDOnSave Property (Word)
Options.StrictFinalYaa Property (Word)
Options.StrictInitialAlefHamza Property (Word)
Options.StrictRussianE Property (Word)
Options.StrictTaaMarboota Property (Word)
Options.SuggestFromMainDictionaryOnly Property (Word)
Options.SuggestSpellingCorrections Property (Word)
Options.TabIndentKey Property (Word)
Options.TypeNReplace Property (Word)
Options.UpdateFieldsAtPrint Property (Word)
Options.UpdateFieldsWithTrackedChangesAtPrint Property (Word)
Options.UpdateLinksAtOpen Property (Word)
Options.UpdateLinksAtPrint Property (Word)
Options.UpdateStyleListBehavior Property (Word)
Options.UseCharacterUnit Property (Word)
Options.UseDiffDiacColor Property (Word)
Options.UseGermanSpellingReform Property (Word)
Options.UseNormalStyleForList Property (Word)
Options.UseSubPixelPositioning Property (Word)
Options.VisualSelection Property (Word)
Options.WarnBeforeSavingPrintingSendingMarkup Property (Word)
Expand Minimize
This topic has not yet been rated - Rate this topic

Options.PasteMergeFromXL Property (Word)

Office 2013

True to merge table formatting when pasting from Microsoft Excel. Read/write Boolean.

expression .PasteMergeFromXL

expression A variable that represents a Options object.

This example sets Microsoft Word to automatically merge table formatting when pasting Excel tables if the option has been disabled.

VBA
Copy 
Sub AdjustExcelFormatting() 
 With Options 
 If .PasteMergeFromXL = False Then 
 .PasteMergeFromXL = True 
 End If 
 End With 
End Sub
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.