PDA

View Full Version : .xml to excel conversion using vba



gidoru
12-13-2013, 04:24 AM
Dear helpers,
I have a question concerning an .xml which i would like to convert into an excel sheet. The .xml given is provided by the german government and is taken out of a database called "ökobau.dat". This database (955datasets) is handling building materials considering their sustainablity characteristics. I want to use this database to write a tool in VBA which is assessing the sustainablitiy of a building. My first step would be to get the data of first of all one dataset into an excel sheet. The uploaded .xml shows a dataset for a special type of concrete.


Could you please help me to convert this .xml into .xls.
I don't need all the datasets:
Infact i need only the

basename
common:class
common:other




Thank you very much in advance for your responses: ) I know it is difficult, but if it wouldn't be i'd be boring and not challenging!

Kenneth Hobs
12-13-2013, 07:00 AM
Welcome to the forum!

I am not sure which part you need. It might be best just to open it in Excel and then get what you need from there. The first time you open it, Excel will need to create a Schema for it.


Workbooks.OpenXML Filename:="X:\XML\1.1.01_Zement_(CEM_II_325)_(A1-A3).xml", _
LoadOption:=xlXmlLoadImportToList