Read Tag Name (Node NAme) XMl VBA

Question

I have the following XML file content:

<HldgVal>
<Amt Ccy="BRL">25641.94</Amt>
<Sgn>true</Sgn>

The "BRL" indicated is the Currency for the amount 25641.94, however, when I try to read the tag Amt Ccy="BRL" in order to get the currency symbol, I just get the node name "AMT" instead of Amt Ccy="BRL".

I am using the following code :

MoedaCaixa = fundoElement2.ChildNodes.Item(1).FirstChild.nodeName

Does anyone knows how to get the full name "Amt Ccy="BRL"" so that I can read the currency?

Thanks in advance

Wojciech Wojtulewski · Accepted Answer · 2017-05-05 15:56:04Z

1

AMT is node name Ccy is node attribute

answered May 5, 2017 at 15:56

Wojciech Wojtulewski

1973 bronze badges

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

1 Comment

Junior Nunes Over a year ago

I got it, the syntax would be : fundoElement2.ChildNodes.Item(1).ChildNodes.Item(0).Attributes.getNamedItem("Ccy").Text Tks a lot

Leandro Coelho · Accepted Answer · 2017-05-05 18:23:08Z

1

AMT is the node name and Ccy is the node attribute. What you want is the node attribute value. Try this:

MoedaCaixa = fundoElement2.Attributes.getNamedItem("BRL").Text

answered May 5, 2017 at 18:23

Leandro Coelho

113 bronze badges

Collectives™ on Stack Overflow

Read Tag Name (Node NAme) XMl VBA

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related