Based on a few hundred key words used to fetch web data (company Ticker symbols) through loop macro, those web data is then put in another sheet.
Problem that I am facing with is after 50-100 loops data is no longer fetched, because memory the Excel use is full with previous data. Is there a possibility that after 10-20 loops cache is cleared through VBA?

Sample workbook is useless because of addins that I use for this specific task. Also 
Please Login or Register  to view this content.
is not helping...