Web query (loop)

[JP Romano]

Hello again ... I'm having some trouble with a workbook (attached), specirfically getting my web queries to execute consistently.

What I'm TRYING to do is create a URL based on some values in column A, then import data from a table on the associated webpage, extract a specific value, then move on to the next value in Column A. Seems to work intermittently...

FYI,
The URLs lead to a series of web pages with corporate financial data. The only difference between each company's "profile" (the web pages) in the URL is a unique 3-5 character segment (which are the values in COLUMN A).

For example, company A is
... &letter=&search=al&extra=374&emittenti=
and company B is
... &letter=&search=al&extra=122&emittenti=

The code is in Module 1, sub getpagetext (the only module and sub I included in the sample).


Can any of you help me understand why I'm not able to consistently obtain the data? Or, any better ways of doing this (could be anywhere from 10 to 500 web pages...)

THANKS!

[JP Romano]

Looks like the problem is relating to the number of web query tables being dumped into the temp directory. When I clean them out, I can do up to 98 at a time.