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?

 

[Fluff]

Doesn't work for me

Nor me.

 

[offthelip]

I ran a few tests:

Sub testwin64()
Dim kk As Integer
#If Win64 Then
  kk = 64
#Else
  kk = 32
#End If
MsgBox (kk) ' this prints 64
End Sub

Sub testwin64a()
Dim Win64 As Boolean
MsgBox (Win64)   ' this prints false
End Sub

Sub testwin64b()
MsgBox (Win64)  ' this gives error variable not defined
End Sub

So I think my suggestion is correct, the scope of the preprocessor constant is just within the compiler, certainly on my machine

 

[Mortiray]

I ran a few tests:

Sub testwin64()
Dim kk As Integer
#If Win64 Then
  kk = 64
#Else
  kk = 32
#End If
MsgBox (kk) ' this prints 64
End Sub

Sub testwin64a()
Dim Win64 As Boolean
MsgBox (Win64)   ' this prints false
End Sub

Sub testwin64b()
MsgBox (Win64)  ' this gives error variable not defined
End Sub

So I think my suggestion is correct, the scope of the preprocessor constant is just within the compiler, certainly on my machine

Unfortunate. I was hoping to be able to declare global constants without having them take up memory, but I guess not. Thanks for your help.

 

[Fluff]

If they don't take-up memory, where are they meant to be stored?

 

[Mortiray]

If they don't take-up memory, where are they meant to be stored?

I imagine since it's a preprocessor command it would replace any instance of the variable name with the value in the code while compiling, so it's hardcoded in instead of accessing it in memory.

 

[Domenic]

You're probably thinking about the #define preprocessor directive in the C language (or maybe other language), which simply substitutes each instance of text with the specified value, after which the code gets compiled.

 

[Mortiray]

You're probably thinking about the #define preprocessor directive in the C language (or maybe other language), which simply substitutes each instance of text with the specified value, after which the code gets compiled.

Yeah I thought VBA had an equivalent