+ Reply to Thread
Results 1 to 2 of 2

#name? error on directory lookup function

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    Chicago
    MS-Off Ver
    Office 2016
    Posts
    31

    Question #name? error on directory lookup function

    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.

  2. #2
    Registered User
    Join Date
    05-25-2017
    Location
    Chicago
    MS-Off Ver
    Office 2016
    Posts
    31

    Re: #name? error on directory lookup function

    I found this code elsewhere. It works perfectly. Thought I'd share:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lookup function/conditional formatting error
    By breyter in forum Excel General
    Replies: 4
    Last Post: 04-02-2012, 07:06 PM
  2. Directory lookup and auto populating file name formula
    By paperwings25 in forum Excel General
    Replies: 1
    Last Post: 11-09-2011, 02:00 PM
  3. Lookup function with a margin of error
    By SIFT-MS88 in forum Excel General
    Replies: 0
    Last Post: 06-16-2010, 01:27 PM
  4. Subfolders in Directory LookUP
    By KingDragon22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2009, 11:34 AM
  5. [SOLVED] Error in lookup function
    By hellotroy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-18-2005, 07:05 PM
  6. [SOLVED] Lookup Function Error
    By Jacinthe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2005, 04:06 AM
  7. Vlookup & Lookup function error
    By Beginner in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-10-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1