- Get link
- Other Apps
RSS is a type of web feed which allows users and applications to access updates to websites in a standardized, computer-readable format. With RSS feeds we can update excel sheets in every second or hours depend upto RSS feed of a website. In this tutorial, we will learn how to import RSS feeds of world's currency rates into excel for your calculations.
1. Make two sheets into excel, one sheet for RSS data and other sheet is main sheet of you application where you will take data reference from RSS feed sheet. To add source of RSS Feed, Go to developer section and click on source
2. Click on xml Maps and then add RSS feed URL. Here, I am suing Exchange Rate Website to get live currency updates.
3. Drag and drop any title of heading i.e title, link, category, description etc into cells of sheet as shown in figure.
4. Use Len, Search, Left and Right Functions to extract number values i.e currency values from a string as you can see in below image at column B row2 there is one string from this string we have to extract 0.39382 number. For this we used different function as shown in figure
5. We can use VBA to quick refresh the RSS data also remove old data. For this, insert button and put following code
Private Sub CommandButton1_Click()
6. Design Format where you can take reference from the sheet
Watch Full Tutorial on YouTube
1. Make two sheets into excel, one sheet for RSS data and other sheet is main sheet of you application where you will take data reference from RSS feed sheet. To add source of RSS Feed, Go to developer section and click on source
2. Click on xml Maps and then add RSS feed URL. Here, I am suing Exchange Rate Website to get live currency updates.
3. Drag and drop any title of heading i.e title, link, category, description etc into cells of sheet as shown in figure.
4. Use Len, Search, Left and Right Functions to extract number values i.e currency values from a string as you can see in below image at column B row2 there is one string from this string we have to extract 0.39382 number. For this we used different function as shown in figure
5. We can use VBA to quick refresh the RSS data also remove old data. For this, insert button and put following code
Private Sub CommandButton1_Click()
Worksheets("Sheet3").Range("a2:d145").ClearContentsActiveWorkbook.RefreshAll
End Sub
6. Design Format where you can take reference from the sheet
Watch Full Tutorial on YouTube
Comments
Post a Comment