Procedure Limit ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I seemed to have reached the Procedure limit in one of my sub routines. Is
this limited by characters, lines of code or what?
If I can move some of the code into new procedures and call the new
procedures from within the large procedure, it this a workaround?

Thanks
 
if you export the module and look at the resulting bas file size, if it
approachs 64K, then it is generally advised to make it smaller by using the
workarounds you describe.
 
So, the Module can only be 64k. If mine is this large, then the new
procedures will need to be in another Module? Or did you mean each Sub can
only be 64K?

If I create new procedures in another module, can I make global variables in
module 1 that can be read in the new module. If so, how is this done?

Thanks
 
Module. Just take some of the subs out of one and put them in a new module.
In general, keep them to a manageable size, better to have to many than too
large.

If you declare global variables in a module, that is Public before any
macros, they will be available to all modules.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
OK, I can declare the varibles as Public. Thanks

Bob Phillips said:
Module. Just take some of the subs out of one and put them in a new module.
In general, keep them to a manageable size, better to have to many than too
large.

If you declare global variables in a module, that is Public before any
macros, they will be available to all modules.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top