I want to pull an RSS feed and process it in Excel VBA, and provide the client the format that they need.
The RSS feed is a text feed and I'm not sure how to get it to format into columns and rows. It appears to use colons for delimiters, but i can't get it to replicate what the client did, pulling it into an Excel worksheet.
The feed is at https://regencydev.adeptia.com:443/adeptia/wsapi/rest/MarketingDataFeed/GetData?User=ShopCtr
The format I want is like in the attached file, which is a sample..