Is it possible to parse XML with using Excel(VBA)?

Question

I have a xml file, I can run it by using Soap UI. In Soap, I open a new worksheet, paste my xml code, and click the run button, and it makes what I want.

I want to the same thing with using Excel(VBA).

Scenario:

I paste the xml content to A1 cell.
Create a button and write the code which I need
Click the button and parse the xml content

Is it possible to do?

Possible duplicate of stackoverflow.com/questions/13620011/… or stackoverflow.com/questions/16423644/… — Ralph
– Ralph, Commented Apr 27, 2016 at 15:54

The scion · Accepted Answer · 2016-04-27 15:29:12Z

0

Only for paragraph 2 you can use the build tool of excel for import xml file into the excel-

Click on tab "data"->"from other sources"->"from xml data inport"

answered Apr 27, 2016 at 15:29

The scion

9829 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to parse XML with using Excel(VBA)?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related