Solved: Define constant path

[CicoMico]

Hello! I want to define Public Const dPath = Environ("APPDATA") & "\Test" in separate module. I am getting this error: Constant expression required. Any help?
Thanx

[Bob Phillips]

You cannot use a function in a constant definition. You need to declare it as a variable and then set it by code.

[CicoMico]

You cannot use a function in a constant definition. You need to declare it as a variable and then set it by code.

hi! :hi: thanx. any help how to define it in one module and use it in others?

[Bob Phillips]

Public dPath As String

Sub SetdPath()
dPath = Environ("APPDATA") & "\Test"
End Sub


use it anywhere thereafter

[CicoMico]

I am an IDIOT! :banghead: :banghead: :banghead: :banghead: THANK YOU

[mdmackillop]

Hi Cico,
Don't forget to mark your thread as solved.
Regards MD