On Sep 27, 7:40 pm, "Robin Hammond"
wrote:
Matthew,

It was an application for a large commercial bank. I can't elaborate I'm
afraid. We decided that everything had to work off named ranges to allow the
code and the interface to work seemlessly together, and had to make the
whole thing look like a web front end - an interesting challenge in itself.

Jan Karel Pieterse name manager was invaluable as was Rob Bovey's code
cleaner since we got out to about 20000 lines of code. We also built a lot
of our own utilities to manage name definitions, consistency, code control,
interface handling and such.

--
Robin Hammondwww.enhanceddatasystems.com

"Matthew Pfluger" wrote in
...



Thanks for sharing.

By the way, "thousands of defined names"? May I ask what project that is
and how you manage them all?

Matthew Pfluger

"Robin Hammond" wrote:

Quick one for the archives.

Error message launching Excel 03 as shown in the title to this post.

Lots of complex solutions about nested named ranges and pivot tables on
msdn
that I messsed with for a while when this started appearing while working
on
a workbook with thousands of defined names.

The actual solution was a corrupted toolbar. So, search for the
excel11.xlb
file and delete it. Problem solved.

Hope this helps someone in the future.

--
Robin Hammond
www.enhanceddatasystems.com- Hide quoted text -

- Show quoted text -

Thanks for the post Robin. I have been fighting this issue for some
time. Had some eMail code that worked just great. Continued with the
project and on final testing the eMail routine created this same
error. I only have 155 NamedRanges with lots of calcs but somewhere
in the process something I did triggered the "Excel cannot complete
with available resources" error.
I searched my HD for excel11.xlb to try your cure but not there. I
have NO file named *.xlb.

Did you come across any other reason for the error in your testing?

Dennis