Hi Patdools,
I did my tests with OneDrive directory and with a non OneDrive directory and I got not differences, your code works well
But, I was able to get a REF error when:
The name in the cell includes a wild-char for instance File123.xls* or File123.xls_
Then the instruction Dir(strPath & cell.Value) work fine because DIR() expects wild-chars and can handle them but
The statement "='" & strPath & "[" & cell.Value & "]" & strSheet & "'!A14" does not handle wild-chars and you get a REF error
So I would suggest you to look for wild-chars in the cell containing the file names
Or debug before assigning .formula I used a dumb variable a3 to debug the REF error to see if the formula is well written
Cheers
Sergio
Bookmarks