saying the procedure is too long

[linqlin]

I use vb script under excell, but it displays : the
procedure is too long, what should i do

My script has many pages of codes

 

[John Nurick]

Hi linqlin,

There is a limit - I think it is 64kb - on the size, or compiled size of
a module. You can avoid it by splitting some of your code into
procedures in other modules.

 

[John Vinson]

I use vb script under excell, but it displays : the
procedure is too long, what should i do

My script has many pages of codes

I would suggest that you axk this question in an Excel newsgroup; this
newsgroup is for table design in Microsoft Access.