Hi,

I am trying to pull in multiple XML feeds into one spreadsheet.

I start the macro and then do the following -

I am using data - XML - Import

After I get to the prompt, I type in http://rss.news.yahoo.com/rss/world and
OK

On the Import Data screen, I go to Properties and check append new data to
existing XML lists and OK

Next, I would like to import another XML list. For example
http://rss.news.yahoo.com/rss/nasashuttle and
http://rss.news.yahoo.com/rss/health.

Can someone send the VBA code that would allow me to do this. Later I can
substitute other URLs.

My current macro does not do this and it would be great to know how to do
this!

Thank you!

Dave