Hi
We will get 200+ xml and each will include 100+ item details so in total 20000+ item details needs to be loaded into excel. the below code take more than an hour and the excel went to not responding.
Can anyone help me to improve this.
For sheet_x = 1 To main_loop ' Loop for multiple xml...