Thread: Excel 2007 Compatibility mode error "Not enough storage to process
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer[_2_] Dean Meyer[_2_] is offline
external usenet poster
  
Posts: 12
Default Excel 2007 Compatibility mode error "Not enough storage to pro
Ron, thanks for your willingness to help out, and for your very nice add-in!

The add-in ran fine with all 106 files, copying one cell from each to a new
sheet. You appear to be closing one workbook before opening the next. My
problem seems to be a limit on how many workbooks Excel 2007 can have open at
once.

Any ideas?

--Dean
Reply With QuoteReply With Quote