Import xml tag data to excel & refresh data

akika

New member
Joined
Aug 5, 2018
Messages
7
Reaction score
0
Points
1
Excel Version(s)
2016
Hi,
In excel workbook version 2016, how can i retrieve data from tags LAST_UPDATE, CCY, TT (in buying and selling) from below xml sample in bold.
And each time the excel is open it should get refresh with the daily rate.

<RATES xmlns="http://www.test.in/exchangeRate>
<LAST_UPDATE>20180807</LAST_UPDATE>
<CCY_LIST>
<CCY_ITEM>
<COUNTRY>EUROPEAN COUNTRIES</COUNTRY>
<CCY_NAME>Euro</CCY_NAME>
<CCY>EUR</CCY>
<UNITS>1</UNITS>
<BUYING>
<TT>49.25</TT>
<TC_DD>49.15</TC_DD>
<NOTES>48.88</NOTES>
</BUYING>
<SELLING>
<TT>43.43</TT>
<TC_DD>43.43</TC_DD>
<NOTES>43.43</NOTES>
</SELLING>
</CCY_ITEM>
</CCY_LIST>
</RATES>
 
Back
Top