LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Compatibility Mode Marsh New Users to Excel 1 February 26th 10 05:48 PM
Compatibility Mode to Excel 2007 Jennifer Excel Worksheet Functions 4 September 16th 08 05:49 PM
EXCEL 2007 OPENING IN COMPATIBILITY MODE FARAZ QURESHI Excel Discussion (Misc queries) 1 May 5th 08 12:23 PM
Excel 2007 - Losing VBA in Compatibility Mode Craig Harrison Excel Programming 1 May 10th 07 05:59 PM
Excel 2007 and "Compatibility Mode" Chaplain Doug Excel Discussion (Misc queries) 2 February 6th 07 04:45 PM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"