Re: What's wrong during VBA project compilatrion?

From: Levan Jgarkava (levanikoNoSpam_at_mailru.com)
Date: 05/26/04 

Date: Thu, 27 May 2004 02:51:48 +0400

Hi,

> There are size limits, but you're unlikely to hit them. Compilation errors
> are usually coding bugs that the compiler can't deal with, in my
experience
> most commonly relating to procedure declarations. Try running the project
> without compiling and test thoroughly ... the bad code usually shows up
> pretty quickly.
It doesn't seems as code problem. It's invariant to code content, but
depends on code size...
here's my answer to another respondent:
A was coding in VB6, then I've created empty Excel Spread*** and imported
a code as VBA project and then tried to compile but there was Excel crush. I
tried to delete one function and code was compiled successfully, then I
tried to uncomment this function and comment other function. code was
compiled successfully, but when I tried to uncomment both functions, excell
crashed down :( (I've tried also with another functions and the same thing
happened)...

Best Regards,
        Levan Jgarkava

> > Hi!
> >
> > I've got a question: Is there any size limitations on VBA Project?
> > Situation: I'm creating VBA classes and modules in MS Excel 2000
> (9.0.2812)
> > and after some additions(no matter what) I can't
> > compile VBA project. There's an exception error signature:
> > -----
> > AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll
> > ModVer: 6.3.91.8 Offset: 00083676
> > -----
> >
> > Thanks.
> >
> > --
> > Best Regards,
> > Levan Jgarkava
> >
> >
>
>