Hi,

Could someone let me know how many lines of code can be
written in a MAcro using VB editor in an Excel file.
Becuase i have written a MAcro which contains around 2000
lines of code (25 Procedures and a few functions). My
Excel file doesn't open now.

Actually the macro was performing well. I included a few
lines of code and saved and then closed the Excel file.
Now when i reopen this,, if i Disable the Macro the file
opens. But when i enable the macro,, it doesn't respond.

Is this because of the lengthy code or some other
problem. I even restarted the system.

I appreciate any help.
Neeraja.

Hi,

In my option, the line of code may be not a source of the problem.
around 2000 lines may not matter.
please find another source of the problem.

"Neeraja" wrote in message
...
Hi,

Could someone let me know how many lines of code can be
written in a MAcro using VB editor in an Excel file.
Becuase i have written a MAcro which contains around 2000
lines of code (25 Procedures and a few functions). My
Excel file doesn't open now.

Actually the macro was performing well. I included a few
lines of code and saved and then closed the Excel file.
Now when i reopen this,, if i Disable the Macro the file
opens. But when i enable the macro,, it doesn't respond.

Is this because of the lengthy code or some other
problem. I even restarted the system.

I appreciate any help.
Neeraja.

If the only thing that changed is adding the lines of code, It is a
possibility. Remove a section of the code and save the file and see if the
problem goes away.

There is no specific line limit that I am aware of, however, export the
module and see if it is more than 64K in size. Others have posted that this
can be problematic.

I would say, just insert another module and put half you code there.

--
Regards,
Tom Ogilvy

"Neeraja" wrote in message
...
Hi,

Could someone let me know how many lines of code can be
written in a MAcro using VB editor in an Excel file.
Becuase i have written a MAcro which contains around 2000
lines of code (25 Procedures and a few functions). My
Excel file doesn't open now.

Actually the macro was performing well. I included a few
lines of code and saved and then closed the Excel file.
Now when i reopen this,, if i Disable the Macro the file
opens. But when i enable the macro,, it doesn't respond.

Is this because of the lengthy code or some other
problem. I even restarted the system.

I appreciate any help.
Neeraja.