Compile error- procedure too large

[Richard Stott]

"Compile error: procedure too large"

I get this message when I attempt to run a macro on a particular Excel
file. The file was created in Office 98 with OS 9. I am trying to run it
in Office v.X with OS X.2.

Someone on a newsgroup said that the macro size is limited with Excel in
v.X. If this is so can anyone tell me how to break up this macro and get
it to run? I created this macro but am not a whiz at programming macros.

Thanks for any help

Dick

 

[J.E. McGimpsey]

"Compile error: procedure too large"

I get this message when I attempt to run a macro on a particular Excel
file. The file was created in Office 98 with OS 9. I am trying to run it
in Office v.X with OS X.2.

Someone on a newsgroup said that the macro size is limited with Excel in
v.X. If this is so can anyone tell me how to break up this macro and get
it to run? I created this macro but am not a whiz at programming macros.

I'm asking for help on this one - I know there used to be a *module*
size limit, but I thought that had been extended or removed in XL98.
I tend to write very modular code, so I've never seen that error.
It's hard for me to believe that the v.X compiler has lower limits
than the 98 one does, too.

In the mean time, code modules do tend to get corrupted over time,
so if you don't have access to Virtual PC, XLWin and Rob Bovey's
marvellous CodeCleaner, one thing you can try is to copy the code in
a module to a text file, delete the module, repeat for any other
modules, then insert new module(s) and paste the code back in.

And you can feel free to send me the file to look at, as long as
it's either zipped or stuffed and sent from the email address above
(otherwise it won't get past my filters).

 

[Jim Gordon]

Hi

I did a search in Google:Groups using the keywords
Procedure Too Large

There were many hits with a variety of different causes for this problem
along with several suggested solutions. Try a search in Google and see if
anyone has already solved the problem for you. If you come up empty, please
post a follow-up message to this thread with more details about your code.
You might be able to rule out several possible causes by checking the Google
results.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>