How to speed up the script below if i have 10000 ip, loop 5000 times on .html page

Hi All,

I have excel spreadsheet with column ip address. I have 5000 unique ip. I tried to extract the data from few website. Can anyone help me how can i optimize my script, I am using CreateObject("InternetExplorer.Application"), it may due to this slow down the performance. Anyone have idea how can i turn my below script using Set xmlDoc = CreateObject("MSXML2.DOMDocument")
or webquery, and this either method perform better performance? I need your expertise to advise me.

Thank you.

Regards,
Micheale

Please Login or Register  to view this content.