Using Central Bank of Myanmar Exchange Rate RSS in Excel
1. Click Developer Tab
(If you cannot see, Click File-->Options-->Customize Ribbon-->Check Devloper-->OK)
2. Click Source in XML (See picture)
3. Click XML Maps...
4. Click Add
5. Paste the following web address in the file name box
http://forex.cbm.gov.mm/index.php/fxfeed/rss
6. OK the XML Schema warning that is shown, then click OK again.
7. Drug item and drop in selected cell
8. Refresh data
1. Click Developer Tab
(If you cannot see, Click File-->Options-->Customize Ribbon-->Check Devloper-->OK)
2. Click Source in XML (See picture)
3. Click XML Maps...
4. Click Add
5. Paste the following web address in the file name box
http://forex.cbm.gov.mm/index.php/fxfeed/rss
6. OK the XML Schema warning that is shown, then click OK again.
7. Drug item and drop in selected cell
8. Refresh data
Download Example:https://www.dropbox.com/s/2k6omav04iw4oxx/CBM_ExchangeRate.xlsx?dl=0
No comments:
Post a Comment