Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
64kB limit error
I can't say from experience, but here's a thread that covers the
bases. http://www.google.com/groups?hl=en&l...b61d7bf&rnum=7 HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF condition Nesting limit error | New Users to Excel | |||
IF condition Nesting limit error | New Users to Excel | |||
IF condition Nesting limit error | New Users to Excel | |||
Excel file 4MB.Copied sheets to a new file.Now=64Kb-easier way? | Excel Discussion (Misc queries) | |||
64kb limit to module code | Excel Programming |