Can't use Option Explicit and Preprocessor constants together?

[Mortiray]

Hello, All,

I'm trying to use Option Explicit alongside preprocessor constants, like in the dummy code below:

Option Explicit

#Const TEST_CONST = 123

Sub TEST_MOD()
    Debug.Print TEST_CONST
End Sub

When I try to run TEST_MOD, I get a "Compile Error: Variable not defined." It does the same thing if I put Option Explicit above the #Const declaration. Do preprocessor constants not work with Option Explicit in this way?

 

[steve the fish]

Prob another variable somewhere.

 

[Mortiray]

Prob another variable somewhere.

The code posted is the only code in the module.

 

[Mortiray]

An update - I tried running this code without Option Explicit, and it outputted "" instead of 123. Is there some sort of setting I have to enable to use preprocessor constants?

 

[offthelip]

I would think that the scope of the preprocessor constants is only for the compiler so that once the compile is done and the code runs the constant is deleted, the runtime constant ( with the same name) is thus undefined

 

[Mortiray]

I would think that the scope of the preprocessor constants is only for the compiler so that once the compile is done and the code runs the constant is deleted, the runtime constant ( with the same name) is thus undefined

Darn. I hoped that preprocessor constants would essentialy go through your code and replace any instant of the constant name with the value at compile time. I thought it'd be cleaner than using Const or Public Const to declare constants - guess not.

 

[steve the fish]

It works perfectly well for me.

 

[steve the fish]

With the # I may add.

 

[Mortiray]

With the # I may add.

That is so strange. I wonder if there's a setting on my excel VBA that needs to be changed. What are the chances you have any VBA Add-ins or References that I don't that are changing this outcome?

 

[offthelip]

Doesn't work for me