I have a similar problem as per
https://www.ozgrid.com/forum/f…-macro-that-freezes/page2
I'm pulling 1800+ web connects at one time and would need to perform this cycle every 30 minutes or so. I tested it out using web connects but can never make it through the cycle without it freezing up on me. Looks like the best solution might be to use XMLhttp but is seems like you need a good background in web tables which i do not have. The information i am trying to pull is from 'Table 2'. How can i get it to pull the correct table information?
[ATTACH=JSON]{"data-align":"none","data-size":"full","data-tempid":"temp_71690_1520029804257_846","title":"FY18WW48lotscan.png"}[/ATTACH]