To quote or not to quote...

[gar]

In a VBA procedure I found that FileExists("<pathname>") returned False while: FileExists(<pathname>) returned True. Is this what is to be expected? If the pathname is obtained by cutting and pasting from File Explorer, it comes with the quotation marks; is there a means, other than manual editing, by which they can be removed?

[June7]

Possibly use Replace() function to remove quote marks.

Whether or not quotes are included depends on method of copy.

Post your code.

[gar]

Possibly use Replace() function to remove quote marks.

Whether or not quotes are included depends on method of copy.

Post your code.

Thanks for your message.

Public Sub quotest()
Dim fs As FileSystemObject
Dim filename As String

filename = InputBox("Filename?", , 0)
Set fs = New Scripting.FileSystemObject
Debug.Print fs.FileExists(filename)

End Sub

If "filename" is enclosed in double quotation marks, this returns "False", without quotation marks it returns "True". Confusingly, if I enter:

Set fs = New Scripting.FileSystemObjectebug.Print fs.FileExists(<filename>)

in the Immediate Widow, the opposite is the case, i.e. <filename> with quotations marks yields True otherwise, False.

[June7]

Your code doesn't work for me, just get compile errors.

This does work for me:

Public Sub quotest()
Dim fs As Object
Dim filename As String
filename = InputBox("Filename?", , 0)
Set fs = CreateObject("scripting.filesystemobject")
Debug.Print fs.FileExists(filename)
End Sub

Putting a full file path of existing file into InputBox returns True. Test with <> characters errors.


Is this your actual code or just something for testing? I would not use InputBox for user input of file path/name.