View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stiv[_2_] Stiv[_2_] is offline
external usenet poster
 
Posts: 1
Default Font errors when performing multiple web queries

Additional information:

When performing the query, I pull the web data in as
straight text, no html or formatting.


-----Original Message-----
I have a macro that searches eBay for closed auctions
given specific search criteria.
After approx. 100-125 individual page queries, some of

the
queries fail with the following error:

"No more new fonts may be applied in this workbook"

See link for image:
http://home.comcast.net/~overfiend/E...0FontError.htm

This error only appears on some of the queries, even
though they are all from the eBay site.
To remedy the problem, I save the file and close it. When
I open it again and continue my queries, the first 100-

125
work perfectly, then the error begin again.

Is there a font buffer or something that I can manually
clear through VBA that gets cleared on Excel close?

I am using Excel 2000 with all the latest patches.

Thanks

Stiv


.