Vba xml group developer tab in Excel

The XML group in Developer tab consists of group of buttons that offers some specific task.

These group of buttons are as given below.

1.Source

2.Expansion Packs

3.Map Properties

4.Refresh Data

5.Import and Export

excel vba xml group developer tab

Source

The Source button facilitates the user to manage XML Maps.

This is done by opening the Source task Pane of XML at the right.

This is as shown below.

The window shows XML Maps, only if the workbook contains any mapping to XML datasource.

excel vba xml group developer tab

Also, with the help of this window, a new XML Datasource can be added as XML Map, as shown below.

excel vba xml group developer tab

Map Properties

This button enables the user to map properties to the XML Datasource.

With no XML map, this button is disabled by default.

Expansion Pack

This button enables the user to attach new expansion pack to the existing XML Datasource map.

This is as shown below

excel vba xml group developer tab

Import

Finally, the import is used to import any XML file into the Excel.

 

You can find similar Excel Questions and Answer hereunder

1) What are the com addins in the developer tab of Excel

2) Here some explanations about how to load an XML document in Excel VBA

3) What is the use relative references in the Excel Developer Tab

4) What is the view code button in the Excel Developer Tab

5) Want to use SQL to manipulate a database. Here some basic explanation to get you started.

6) What is the design mode in the developer Tab in Excel

7) What are the addins in the developer tab in Excel

8) What is a recordset in Excel and how to use it. Here are some basic explanations

9) To easily identify sheets belonging to different Business Divisions, I would like to color code tab names - is it possible?

10) Here some explanations about the XML DOM node in VBA, DOM stands for Document Object Model

 

Here the previous and next chapter