Hi guys and girls,

I've got a list of about 600 products where I need to get inventory data.
I can get this per product from an internal site, where I copy a table that shows specifically where the products are stored (warehouse, location).
Since VBA webscraping would do this in serial it takes around 10~15 minutes to get all 600.

I can make this time a lot shorter by doing it parallel via VBScript.
My VBA code dynamically creates the VBScript below that pulls the data and puts it back into the Excel sheet.
It works, but only for 50~60 products at a time, no matter how many VBScript files I launch. The rest fails and doesn't return output or doesn't put it into the sheet.
Does anyone know any reason why this might happen?

Is there something I can do to adjust my vbscript code so more will succeed?
Thanks for any help!

VBSCRIPT:

Please Login or Register  to view this content.
Would writing it to separate text files and then reading the textfiles output through VBA be more succesful/quicker?
Thanks again for any help - I'm at my wits end