Lawrence Mrazek
lmrazek at lcm-res.com
Wed May 24 11:20:11 CDT 2006
I'm using a lot of named ranges, since these data groupings change from month to month. I wonder if this could have something to do with the issue. I'll check Excel help and report back to the list ... Thanks! Larry -----Original Message----- I don't think that would help. If it runs on one machine and not the other it may truly be out of memory although this seems strange. I have sheets that exceed 8 mg. Of course not all workbooks are equal in the kind of resources they use. Check out Microsoft Excel specifications in the Excel help and see if any of those limits apply to your situation. Depending on the situation I have cured this problem in the past by changing lookup formulas to values, reducing pivot tables, etc to shrink the worksheet. Good luck Jim Hale -----Original Message----- Hi Jim: No, I don't think so. This has happened on the first run after a reboot, and I haven't been able to identify any open processes using task manager even after a run completed. Would saving (before the last worksheet generated), closing the instance of excel, then re-opening excel possibly solve this? Like I said, these are pretty large files. Thanks. Larry Mrazek LCM Research, Inc. www.lcm-res.com lmrazek at lcm-res.com ph. 314.432.5886 fx. 314.432.3304 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim Sent: Wednesday, May 24, 2006 8:42 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] "Out of Memory" Error ... VBA Export to Excel Is it possible old instances of Excel are still in memory? Excel loves to hang around even when you think you have properly closed it from previous runs. Use task manager to see if this is the case. If it is there are a number of voodoo rituals availasble to kill the zombies. Jim Hale -----Original Message----- From: Lawrence Mrazek [mailto:lmrazek at lcm-res.com] Sent: Tuesday, May 23, 2006 9:35 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] "Out of Memory" Error ... VBA Export to Excel Hi Folks: I have a fairly complex application that dynamically creates an excel workbook and worksheets from VBA (formatting is done via an Excel template), then populates the sheets with data from recordsets, as well as formulas using named ranges. Typically, when they're finished generating, they weigh in at about 5-6 megabytes. While they generate OK on my development machine with 2gb RAM, the larger exports have been failing at the last worksheet when I run it on a machine with 1gb or less total RAM. Basically, the export stops and Access displays a message box stating "Out of Memory". I've been closing the recordset objects, setting them to "nothing", but I'm still getting the error. Any ideas on how to troubleshoot this issue? Thanks in advance. Larry Mrazek LCM Research, Inc. www.lcm-res.com lmrazek at lcm-res.com ph. 314.432.5886 fx. 314.432.3304 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com