VBA Method of 'From XML Data Import'

[default_name]

Hey everyone,

I am using Excel 2016.
I would like to apply VBA script to a button I have made which calls the existing Excel command found at Data>From Other Sources>From XML Data Import.
Is this even possible?

I am just trying to simplify things with a button so that the users of my workbook don't have to go through various toolbars, etc for certain commands.

 

[sijpie]

Click on the 'record macro' button at the bottom left in Excel:

Then carry out your xml import

then press that button again (it has changed to a square)

You can now press Alt-F8 to run the macro or choose to edit it.

You can then set up a button linked to the macro.

Let me know how you get on