Excel Crashing when changing global const

[Chance1234]

This ones got me,

when i try to comma out a global const in my code excel crashes.

I have exported, reimported everything

the global const is not called until a user hits a button so there is no code in the start up routine ihave that would call it.

any dieas on where to begin

Chance,

F, G + _HH

 

[GlennUK]

Hi Chance,

how does Excel crash exactly? Any messages?

Can you show some of your code too?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Hi,

"the global const is not called until a user hits a button "

What difference does that make?

The complier assigns memory for ALL variables and constants at run time, I beleive.

But what difference would that make to an action that you take BEFORE run time: commenting out your global constant???

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Chance1234]

Exactly, extremly miffed.

The following is the lines

'Global Const str_clientpath As String = "\\XXXXX\clients" ' Live version
Global Const str_clientpath As String = "\\YYYYYY\clients"  'development

sometimes i get a

This action will reset your project

mopst of the time it crashes.


Chance,

F, G + _HH

 

[SkipVought]

You CANNOT do that in a break! VB has already assigned the constant.

You must do the BEFORE runtime. It would be like trying to assign a different value to a constant like a variable.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Chance1234]

Skip,

This is happening before i have ran any code, this is just going into the editor

Chance,

F, G + _HH

 

[PHV]

This action will reset your project
So, code IS running ...

 

[Chance1234]

what code is running is beyond me, This is a bog standard install of excel and there are no thrid party add-ins


Chance,

F, G + _HH

 

[SkipVought]

There must be some event kicking off your code.

Maybe not THIS procedure, but some procedure IS running.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Chance1234]

copied to new machine, macro security level on high , crashes on open

Chance,

F, G + _HH

 

[SkipVought]

Are Macros Enabled or not?

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Chance1234]

same on enabled and not enabled,

Chance,

F, G + _HH

 

[SkipVought]

If it happens without regard to macros being enabled, then it's not macros within the workbook.

Do you have any other workbook referenced (like a PERSONAL.XLS) or addin. For instance, if I have macros DISABLED, my Personal.xls, which opens whenever Excel opens, can run macros in functions that I have installed in the workbook I disabled macros in.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[combo]

In VBE Tools>Options dialog, 'General' tab, untick 'Notify Before State Loss'. This is useful when working with running project, but generates annoying messages when no code is running too.

combo

 

[Chance1234]

this one really has us beat, if i remove the module then it works fine,

Chance,

F, G + _HH

 

[xlbo]

might be a corrupted module

Copy code to notepad
Remove module
Insert new module
Copy code back in

See if it still bugs out

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question