I have several xml files that I would like to be able to import specific data from into an excel workbook and I am not sure where to start to get this to automated instead of dragging and dropping each time from the XML Source area. The image attached is just the first portion of the xml file. What I am trying to do is extract very specific lines of that data only to be imported into excel. The lines of data will be the same all the time for each xml file I am trying to import.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro or VBA to import specific data from xml file
- Thread starter fcfcadd
- Start date
Welcome to MrExcel forums.
This can be done with a VBA macro which uses the MS XML class library, for example as a starting point:
www.mrexcel.com
Change the .Load line to your local file:
And the For Next loop would need changing for your specific data. The macro requires a reference to Microsoft XML, v6.0, set via Tools -> References in the VBA editor.
This can be done with a VBA macro which uses the MS XML class library, for example as a starting point:
Parse xml website
- false 00:00:00:00:00:00 000.000.000.000 00000 15 days, 16:25:53 2011/10/12, 14:49:11 aa-00.0.0.0-aa aa-00.0.0.0-aa Disabled Enabled 1 DOCSIS 2.0 Capable Registered 00/0 00/0/0 000000000 00000000 -0.0 00.0 00.0...
Change the .Load line to your local file:
.Load "C:\path\to\your file.xml"And the For Next loop would need changing for your specific data. The macro requires a reference to Microsoft XML, v6.0, set via Tools -> References in the VBA editor.
Upvote
0
You may need to change these lines:
to:
Post your code if you still get errors and tell us the exact error and on which line it occurs.
Remember, the example link is for that specific question and the code for your data will need extensive changes. The example was just to show the basic idea, with SelectNodes and SelectSingleNode.
VBA Code:
Dim objDOMDocument As DOMDocument
Set objDOMDocument = New DOMDocument
VBA Code:
Dim objDOMDocument As DOMDocument60
Set objDOMDocument = New DOMDocument60Post your code if you still get errors and tell us the exact error and on which line it occurs.
Remember, the example link is for that specific question and the code for your data will need extensive changes. The example was just to show the basic idea, with SelectNodes and SelectSingleNode.
Upvote
0
Similar threads
- Question
- Solved
