I am doing some work in an environment where they only way to export is via RSS. In that RSS, there are rows of fields that I need to input into Msft Excel. I see that Excel can import an XML file with the appropriate XCD schema, and sure enough, I got pretty close just by creating a map file, but I cant get all of the fields out. We have an old RSS Feed in our app that I cant get individual fields exported. If I view it in Google Viewer, it looks great, but I still have to cut and paste the data. I would like a simple, maybe VB macro to import into Excel and to parse out the 10 or so fields in each instance. There are usually 5-10 instances in each RSS XML file, so they arent even that big. I have included example RSS XML file below, and a screen grab of how it looks in Google RSS Viewer.
I would like for someone to show me how to :
1. map the RSS XML in Excel with the example XCD mapping file
2. Automate the whole process where I could simply click on export RSS and my browser would import, parse, and pass to MS Excel