rss

  1. F

    Importing RSS Feeds into Excel (XML V1.0 and UTF-8)

    Hi, I am trying to insert an rss feed from the web into Excel, but this seems to have stopped working ever since May 2019. The link I am trying to insert is: https://www.totaljobs.com/JobSearch/RSS.aspx?Keywords=Performing-arts&LTxt=Birmingham&Radius=10 The data appears correct when you...
  2. M

    Unable to fetch data from a webpage through web scraping

    How should I scrape this webpage https://www.bseindia.com/stock-share-price/asian-paints-ltd/asianpaint/500820/ and specifically need the ROE figure which is mentioned in the table. I used following code in excel. `Sub FetchData() With ActiveSheet.QueryTables.Add(Connection:= _...
  3. F

    Finding URL Address of Source Data

    Hi, I have previously added some rss feeds into an excel document (using the Get External Data Function), so there is a nice looking table present in a tab. I now want to add a similar rss feed into a different tab - simply changing a geographic location in the url. However, I can't for...
  4. F

    Automatically adding columns to RSS tables in excel

    Hi, I have a spreadsheet with numerous tabs in. Every single tab has a similar RSS feed imported into it (so it becomes a table). At the moment the final column on each tab (and therefore in each table) is always going to be column H. Is there any easy way to therefore automate the following...
  5. S

    Got error while extracting Bing RSS results

    After long time, VBA code is not working properly today. Got run-time error '1004':application-defined or object-defined error When I clicked Debug It showed me at Sheet1.Cells(rCount, ItemIndex + 1).Value = Node.nodeTypedValue I think Bing changed its fields, do not know exactly. Here is the...
  6. M

    Extract date from a string pulled from RSS Feed : Tue, 06 Feb 2018 23:23:40 +0000 to 06/02/2018

    I need to use the date of some fields that are imported from an RSS feed in Google Sheets. The date comes in as Tue, 06 Feb 2018 23:23:40 +0000 Using =MID(A1,FIND(",",A1)+2,256) I get the stuff after the comma, so almost there, but just need to ignore the time section 06 Feb 2018 23:23:40...
  7. S

    How to change VBA code to import google cse API RSS feed

    Hi below code extracts rss from bing.com I Wanted to change below code to import rss feed from google CSE api urls list Attached sample file. https://spaces.hightail.com/space/dFNYS0QY0G I do not want post google cse API url in here. Dim rCount As Long Public Sub GetDataFromBing(ByVal strurl...
  8. S

    How to get RSS feed of google cse API in excel 2013 with VBA

    Hi Friends, Trying to get RSS feed of Google CSE API example https://www.googleapis.com/customsearch/v1?alt=atom&cx=[id]&key=[API key]&q= [keywords] into excel 2013 with VBA code. I am trying to extract only first item of results (first item = title, url, description, date) please help me...
  9. R

    Data from PowerPivot via RSS Feed into Excel

    I am using an RSS feed (.atomsvc) to create a link into PowerPivot from my source data which I believe is being posted from an SQL Server. I have been able to create the link between the feed and the PivotTable, but I need get this information into a regular Excel worksheet without creating a...
  10. I

    Generate a News Feed with Excel

    I'm interested in using Excel to create a news feed of a vehicle inventory. I've researched many possible solutions including this one http://www.automateexcel.com/2004/12/15/create_an_rss_feed_with_excel/ However, I've not found one that validates and in particular I'd truly love to find a way...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top