Thread: Excel 2007 Compatibility mode error "Not enough storage to process
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Excel 2007 Compatibility mode error "Not enough storage to process
Hi Dean

curious : If you test it with this add-in to get the value of one cell
for example do you have the same problem then ?

http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean Meyer" wrote in message ...
I have a VBA application in Excel that opens 100 workbooks. It works fine in
Excel 2003. But in Excel 2007, it fails half way through with the error
message "Not enough storage to process this command." Both machines are
running XP, and the pagefile is set to the max 4096meg. Any ideas?
Reply With QuoteReply With Quote