Constant expression required

[sharky12345]

Guys, forgive me but I am just starting to understand constants and I am getting 'Constant expression required' with this;

Public Const ActionsFolder As String = ThisWorkbook.Path & "\Actions\"

Can anyone help me understand why it isn't correct?

 

[Joe4]

I don't think you can apply a formula to a constant.
Since ThisWorkbook.Path is variable (it can change), it isn't really constant.
You would not want to use a Constant in this case.

Perhaps what you are really looking for here is a Public Variable?
https://msdn.microsoft.com/en-us/library/office/gg264241.aspx

 

[RedBeard]

Because you have included a value that is variable

ThisWorkbook.Path

.
This can change, thus it is not constant.

 

[Rhodie72]

Guys, forgive me but I am just starting to understand constants and I am getting 'Constant expression required' with this;

Public Const ActionsFolder As String = ThisWorkbook.Path & "\Actions\"

Can anyone help me understand why it isn't correct?

What you are trying to do is assign a variable to a constant. This is not possible. A constant cannot change. You would be better off using a public function for that as in:

Public Function ActionsFolder(myPath as string) As String
if myPath ="" then
    ActionsFolder = ThisWorkbook.Path & "\Actions\"
else   
    ActionsFolder =""
end if
end function

This method will provide the action you require and also keep the declaration open for all other calls to it.

 

[sharky12345]

Thanks for your replies guys - makes sense now!