Name

workbook.XmlMaps

Synopsis

Returns the collection of XML maps in a workbook. Use this collection to select an existing XML map to use for importing data or when refreshing XML data displayed in a list. The following code uses the XmlMaps collection to get the ExcelObjects map and then refreshes the data displayed through that map:

Dim xmap As XmlMap
Set xmap = ThisWorkbook.XmlMaps("ExcelObjects")
xmap.DataBinding.Refresh

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