![]() |
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 . |
Font errors when performing multiple web queries
|
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com