I've been using Google Docs with the importXML function to pull information off many external XML feeds at the same time. This has been very useful but I'm starting to have a lot of trouble, specifically in that Google Docs is limited to only 50 such functions on any given spreadsheet, and I need several hundred. However, to my knowledge Excel has no similar function. Using the XML developer functions in Excel I was able to pull up part of the feed that I needed, but the issue is I need to be able to query 50+ external XML feeds at the same time, without manually importing them all into the document.
I was looking online and I found this blog post about RSS feeds in Excel: http://www.s-anand.net/blog/rss-feeds-in-excel/ This blog post talks about creating a user created function using XPath that allows for this syntax (basically the same as the importXML function in google docs): XPath(url,query) where the query is the xpath to a certain element within that external XML feed. ex. "// election/candidates/candidate" Unfortunately that blog post doesn't say how to create that XPath function. I had never heard of user created functions previously, but a bit of hunting and I learned a lot about them. I also landed on this group. I have little understanding of the syntax necessary to create such a function. One of the things this function would have to do is be able to take cell data as the URL (i.e. XPATH(A3,query)) which the (to my knowledge) the developer XML tools can't do. Could someone please help me as to how I would write such a function in the Excel VBA editor? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
