Name

xmlmap.PreserveColumnFilter [= setting]

Synopsis

True preserves mapped list column filters when data is refreshed. False resets the filter to show all the data. Default is True.

The following code displays the PreserveColumnFilter and other general property settings for an XML map in the Debug window:

Set xmap = ThisWorkbook.XmlMaps("Numbers_Map")
Debug.Print "Preserve column filter? " & xmap.PreserveColumnFilter
Debug.Print "Preserve formatting? " & xmap.PreserveNumberFormatting
Debug.Print "Root node name: " & xmap.RootElementName
Debug.Print "Root namespace: " & xmap.RootElementNamespace
Debug.Print "Save data source definition? " & xmap.SaveDataSourceDefinition
Debug.Print "Show validation errors? " & xmap.ShowImportExportValidationErrors

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial