ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Font errors when performing multiple web queries (https://www.excelbanter.com/excel-programming/287899-font-errors-when-performing-multiple-web-queries.html)

Stiv[_2_]

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


.


excelcior

Font errors when performing multiple web queries
 
if you will mail me the macros to
Thank you, Janet

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



All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com