Constant Expression Required

[wsnyder]

Hi all,

Using Excel 365.

My code is returning an error:

Compile error:
Constant expression required

I believe I declared the Constant correctly.
I tired to move the path directly to the function call, bypassing the constant declaration and it worked as expected.
Not sure what is goin on here?

Thanks,
-w

Sub Test_GetFile()

    Const zPath As String = "\\Folder\Subfolder\SubSubFolder\SubSubSubFolder\SubSubSubSubFolder\"
    
    GetFileNames Path:=zPath
    'GetFileNames is a Function using FSO


End Sub

 

[Rick Rothstein]

That compiles fine in my XL2019 version of Excel.

 

[Peter_SSs]

I presume that you do not actually have this exact line in your code?

Const zPath As String = "\\Folder\Subfolder\SubSubFolder\SubSubSubFolder\SubSubSubSubFolder\"

If not, what is that actual line of code?

 

[wsnyder]

I presume that you do not actually have this exact line in your code?

Const zPath As String = "\\Folder\Subfolder\SubSubFolder\SubSubSubFolder\SubSubSubSubFolder\"

If not, what is that actual line of code?

Thanks Peter,

It is a path to a file on company network
I copied and pasted the path to Windows Explorer.
I was able to navigate to the requested subfolder in W/E.

Thanks,
-w

 

[RoryA]

You would only get that error if there's something wrong with what you actually have in the code (eg you try and concatenate a cell value or variable into the path)