KalluMama
asked on
Procedure Size
Is there a limit on how big a procedure can be? I keep getting an error that my procedure is too big...
Thanks,
KalluMama
Thanks,
KalluMama
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The following is an excerpt from MSDN.
CAUSE
The maximum size of the internal code for an individual procedure in Visual Basic is 64K bytes. Microsoft Visual Basic for Windows uses Microsoft Visual Basic for Applications, which generates more generic internal code. This generic code allows for compatibility with a wider range of processors. This makes the internal code larger, so it can cause very large procedures to exceed the 64K limit and fail to compile.
WORKAROUND
Split the large procedure into two or more smaller procedures.
STATUS
This behavior is by design.
CAUSE
The maximum size of the internal code for an individual procedure in Visual Basic is 64K bytes. Microsoft Visual Basic for Windows uses Microsoft Visual Basic for Applications, which generates more generic internal code. This generic code allows for compatibility with a wider range of processors. This makes the internal code larger, so it can cause very large procedures to exceed the 64K limit and fail to compile.
WORKAROUND
Split the large procedure into two or more smaller procedures.
STATUS
This behavior is by design.
ASKER