I use 1 file per year with 14 28 day sheets (over lap of months). I’m trying to copy the data from one file to the next.
However, since the directory they are in is called RED’s (with the apostrophe) I get Err.508 in the cell. On the formula bar I see:
I tried putting double quotes " around the directory and file name i.e.
But that didn’t work. As a test I renamed the directory to REDs and it worked. Other programs/computers reference RED’s so I’d rather not rename permanently it if possible.