Hello

Unfortunatly my expiriance with macro is on level 0.
I have XML files, there are more then 1000 files which are included to one directory.
These XML files contain specific data, unfortunatly after some automatic import (using some specific script, which i found on the internet) its really hard to look for them.

When i manualy add in developer option and import specific data from XML files, creating MAP, i`m able to see exactly what i want.
However i`m looking for automation mode.


MRN WAGA OPIS WARTOSC WALUTA KURS
14PL0000000000 0,5 DEKODER 3000 NOK 0,5049

Here is XML Code which contain data



Please Login or Register  to view this content.
I`m looking for script which will get all choosen or usuful data for me and place to the columns and rows


I`m interested with this type of data

<Zwolnienie NrWlasny="1234567890" MRN="14PL441234567890" CRN="1234567890">
<Towar OpisTowaru="opis" MasaNetto="0.500" KodTowarowy="12345678">
<Transakcja Rodzaj="51" Wartosc="1000.00" Waluta="USD" Kurs="3.023"/>
<DokumentWymagany Kod="9DK8" Nr="DOKUMENT OGL"/>

In excel it will look like that

simple.png

I found on the internet, macro which getting xml files from directory, as i previously said, it`s containing all information which are mentioned in XML


Is there chance to recevied some help from your guys ?

Code of Internet Macro which i found:

Please Login or Register  to view this content.