Embedding a live RSS Feed into Excel

EE Pros,

Is there an easy way to embed an RSS News feed into an Excel WS where you can have live streaming populating the cell?  I would envision enlarging the cell and using wrap text but how you would handle overflow and the feed itself is not clear.

Any thoughts or ideas or perhaps a quick example?

Thank you in advance,

B.
Bright01Asked:
Who is Participating?
 
TheNauticanConnect With a Mentor Commented:
I had never thought much about needing to do this, but someone else had.

http://chandoo.org/wp/2008/07/30/rss-feeds-excel/

Doesn't appear to be a way to directly do it with excel, but this seems like a decent workaround. I can't test since google docs is blocked by my work.
As for enlarging the cell you can use autofit.

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim nextTarget As Range

    Set nextTarget = Range(Selection.Address) 'store the next range the user selects

    Target.Columns.Select 'autofit requires columns to be selected
    Target.Columns.AutoFit

    nextTarget.Select
End Sub

Open in new window


If you get this working let me know.

Regards,
-Naut
0
 
Bright01Author Commented:
Naut,

Thanks for the note.  I have no experience with Googledocs but must think if it can be done in setting it up there and then linking/importing it into Excel; it must be able to be done in Excel natively.  I downloaded the sample but again, it doesn't update ( I think you have to have Googledocs running).

Let's see if anyone else knows how to do this in Excel.

Thanks,

B.
0
 
Bright01Author Commented:
Got it!  Thank you!

B.
0
 
Naresh PatelTraderCommented:
Wow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.