• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pull data from XML file to excel

Manish Sharma

Manish Sharma

Member
Dear Friends,

I am trying to pull XML data (which is saved in my desktop) to excel. Can I get any help from anyone of you. or if you can suggest any tool/excel addin to do the same then it would be a great help.

Regards,
 
There should be a million ways to do it! PowerQuery in 2010/13, 07 has some specialized functionality for working with xml. You might be able to find a way to trick MSQT into doing it too.
 
dan_l said:
There should be a million ways to do it! PowerQuery in 2010/13, 07 has some specialized functionality for working with xml. You might be able to find a way to trick MSQT into doing it too.
Click to expand...

Hi dan_I thanks for replying, I am downloading PowerQuery, meanwhile if you dont mind can you please tell what id MSQT.
Also can tell me please tell me, if it is possible to import data with VBA code. If yes then can you help me with the code.
 
It depends exactly on what you're trying to do. I think powerquery and excel's onboard xml mapping both feature a refresh button somewhere, so you could definitely just use the recorder to see what that button actually does. I'd expect that it would be like "activeworkbook.connections("somethingorother").refresh" or maybe "activeworkbook.refreshall" or something. But that's just using the existing plumbing and some obvious automation.

If you were going to try to query the xml document with VBA, I'd suggest ADO which is documented all over the interwebz. I'm not sure whether it supports querying an xml doc, but that functionality is pretty robust.
 
You must log in or register to reply here.
Back
Top