Re: VBA6 cores when hitting Reset button on the VBA IDE

OK, there is your problem then.
You have some poor code with lots of errors and you will have to fix them all.

Make sure you always have Option Explicit by doing in the VBE:
Tools, Options, Editor, tick Require Variable Declaration.

RBS


"Tom Med" <tom.medland@xxxxxxxxxxxxxx> wrote in message news:1190888652.393446.165490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have been trying to work this out, however after changing my classes/
module to have option explicit at the top has been problematic. As
VBA now cores when I hit the compile button as I am trying to find all
the errors.

I think this is something to with VBA mis-managing objects and trying
to reference deleted objects, but it seems nigh on impossible to
detect what the root cause of this is.

Thanks
Tom

On 27 Sep, 10:03, "RB Smissaert" <bartsmissa...@xxxxxxxxxxxxxxxx>
wrote:
Does the code compile when you have Option Explicit
at the top of every module, form and class?

RBS

"Tom Med" <tom.medl...@xxxxxxxxxxxxxx> wrote in message

news:1190883697.609810.313600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

>I have tried this, or I am using an adapted version of this that
> imports and export all the code on opening and closing of a workbook.
> I think it is something to do with the destruction of the objects that
> I am creating in the VBA. Both the close of the workbook and the stop
> method seem to cause these problems

> Thanks
> Tom

> On 26 Sep, 21:02, "RB Smissaert" <bartsmissa...@xxxxxxxxxxxxxxxx>
> wrote:
>> Download and run the VBA Code
>> Cleaner:http://www.appspro.com/Utilities/CodeCleaner.htm

>> Quite likely it will fix the problem.

>> RBS

>> "Tom Med" <tom.medl...@xxxxxxxxxxxxxx> wrote in message

>>news:1190828014.685443.266670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

>> > VBA is just about driving me mad... it seems every week now I come
>> > across something new that will cause it to crash. This time it is
>> > when I hit the stop/reset button on the VBA IDE. I have no idea >> > what
>> > is causing it or where to start looking even. Has anyone else come
>> > across this problem, and what might be causing it and how to fix it?

>> > Does anyone know how you can detect why VBA crashes? I seem to have >> > it
>> > crashing if you try and do anything other than simple formatting of
>> > cells. This trial and error then crash and restart style of
>> > programming is the most mind numbing thing in the world.

>> > Is there anyway to debug into the VBA6 dll to find out what the root
>> > of these problems are? I am hitting about 20+ crashes a day at the
>> > moment, and it is driving me mad

>> > Thanks
>> > Tom



.