VBA web scraping script running too quickly

[czarna dziura]

Hi all,

I've created a script (I can post upon request) which walks through a column of stock symbols, then using google finance, grabs the company name, sector, and industry for each symbol.
The problem I'm encountering is say I have the symbols AAPL, GOOGL, and MSFT, the output should look as follows:

Symbol	Name	Sector	Industry
AAPL	Apple inc	Technology	Computer Hardware - NEC
GOOGL	Google inc	Technology	Search Engines
MSFT	Microsoft Corp.	Technology	Software - NEC

<tbody>
</tbody>

And does if I step through the code manually. But if I run the script the output looks like the loop is getting ahead of itself like so:

Symbol	Name	Sector	Industry
AAPL	Apple inc	Technology	Computer Hardware - NEC
GOOGL	Apple inc	Technology	Computer Hardware - NEC
MSFT	Microsoft Corp.	Technology	Software - NEC

<tbody>
</tbody>

Basically one company symbol is being used for two rows (sometimes rows are skipped, or partially done), and the only thing I can think of to fix it is to force the script to pause every loop for 10 seconds for everything to catch up. Does anybody have a more elegant solution?

A follow up question to this, is that it will be applied to data pulled using power pivot, and I'd like to have it run on the symbols while still in the power pivot table instead of being exported and pulled back into power pivot. Is this possible with user made macros?

Thanks!