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


.

if you will mail me the macros to
Thank you, Janet

--
Message posted from http://www.ExcelForum.com