[zna213]

Hello guys

I have the following problem. I have an Excel sheet which has to be filled in with data from an big XML file.
At first I read in the xml file with the following code.

Code

Sub openxXML()

Dim xml As Workbook
Dim varxml As Variant

varxml = Application.GetOpenFilename("All Files(*.*), *.*,XML-Files (*.xml),*xml*", 2, "Choose XML-File", _
"choose", False)

If varxml = False Then
    MsgBox "No Data selected"
    End If
    
End Sub

But now I don't now how I can fill in my excel file, is there anybody who can give some tips or input where I can watch some tutorials or read something.

Thank u

[flAmingw0rm]

Use a library like this one to create your XLS file: https://github.com/JanKallman/EPPlus

[maype]

Or you can simple using available library for Office excel.

See link: http://www.c-sharpcorner.com/UploadFile/...g-C-Sharp/

Basically you need to feed cells of the sheet. Its pretty sefl explanatory. Hope you succes.

[RiperFish]

check this list :
https://www.youtube.com/watch?v=IExTaxXN...lcA5vRollM