[AccessD] "Out of Memory" Error ... VBA Export to Excel (SOLVED)

Glad to hear you figured it out.  I learned about the 1024 byte limit.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Friday, May 26, 2006 3:51 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] "Out of Memory" Error ... VBA Export to Excel
(SOLVED)


Hi Folks:

Well, I was looking in the wrong place for this error. Since these are
fairly complex worksheets, with a lot of formulas using named ranges, I
SHOULD have looked at Excel to make sure that what I was trying to write to
the cell was valid. Of course, it wasn't, as some of my grand total formulas
exceeded the 1024 character limit of a formula in excel. This caused the
generic "out of memory" error. 

I was able to fix the error by shortening my naming convention, and
everything is building correctly.

Thanks to everyone who responded, you helped me eliminate some of the other
possibilities for this error.

Hope everyone has a safe weekend!

Larry Mrazek