Hey everyone,
I'm using the below code to check if a file location exists on my computer. I then just do =checkdir(A1) to check each one. It works.
However, I'm trying to integrate it with a query pulled from access, and the second the range turns to a table, I get a #NAME? error.
Even when I revert to a standard range, the error remains. I'm lost. Can anyone offer any insight into this?
Please Login or Register to view this content.
Bookmarks