The single quotes cause the string to be read "as is". So its looking for a file name with %NRQUOTE.
If you change it to double quotes, it goes right back to insisting that it cannot resolve C.
Would this be easier if I macro coded instead of just going straight in like I am?
So I'm trying to pull in an excel file from the company directory. Unfortunately there is a an "&" in the file name that I'm unable to alter. Its near the root of the structure and I don't have access below that point to store files.
Normally, the solution would be to use single quotes and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.