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
.