I have a script that works, but I can’t add my desired filename to the folder path:
FileN = GetFileNameWithoutExtension(sURL) & "\" & sSheetName & ".csv"
Interestingly, the highlight above indicates a syntax error, but not in the editor itself:
However, the file operation on the above name fails until I remove the & " \ " and then it works, but of course it ends up in the wrong folder with a filename that begins with the folder name instead.
What’s the correct way of doing the above?