View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave the Wave Dave the Wave is offline
external usenet poster
 
Posts: 6
Default 64kB limit error

I am working on an Excel 97 application does that a great deal of VBA
processing. (The application should've been done in Access, but time and
budget constraints made Excel the tool of choice.) When I try to run one of
the procedures that I just added some more code to I get an error message
I've never seen before. "When compiled procedure exceeds 64kB memory
limitation....." is my approximation of the error response. I don't get
this message on my development machine, but I do on the machine where this
application is normally used.

I assume I have to break the procedure into smaller chunks to rectify this
issue; however, I would like to know a little more about the condition
before I just put a bandaid on it and send it back out.

I could not find anything on the MS website or via searches in some of the
news groups I know of. If someone has addressed thid issue before, please
send me a link to the resource/s.

Thanks in advance.