Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I try to connect to an Excel file in a shared directory. The file path is like
\\nA-folder1\nB-folder2\
whici is put in a variable.
But the two \n are replaced by return codes so the variable looks like the following afterwards:
"\
A-folder1
B-folder2"
How to make sure this variable is understood as a simple directory path?
Thanks
enclose the path in double quotes or square brackets: "\\nA-folder1\nB-folder2\*.xls" or [\\nA-folder1\nB-folder2\*.xls]