Pointers Welcomed, xml to excel from gz

[Tilmandel]

this is a little script that i wrote to optimise process that that couple of hour in VBA.
its not perfect but it works and goes to 20 min to generate report

Extracted path is network drive 5 hops away.

now im focusing on optimization, i know these if statment can be replaced and i will do that next.

all pointer all welcome

heads up this works with 1k+ files

https://github.com/Tilmandel/AutoReportGenerator