Results 1 to 12 of 12

Retrieve File name based on cell value (match cell value to file name in directory)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    SOUTH AFRICA
    MS-Off Ver
    MS EXCEL 2016
    Posts
    119

    Retrieve File name based on cell value (match cell value to file name in directory)

    Good day

    Please assist on how to retrieve File name based on cell value (H12) to match cell value to file name in the following location below

    V:\FINANCE\99 Vibramech\Sales\Job reconciliations
    If the file exist in the above folder location to write this Note "Recon Done" on cell: H14

    I've attached the file and the screen shot for the file location

    Regards;
    Tshepo
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-06-2023, 02:23 PM
  2. VBA saving row data as xml file to directory specified in row cell
    By BGUNN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2015, 07:07 AM
  3. [SOLVED] Compare cell in one file to same cell in another file, continue macro only if cells match
    By CherylC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2014, 09:31 PM
  4. copy file to a directory if cell G6 equals to a certain value
    By w8itn4you in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 06:58 PM
  5. Replies: 3
    Last Post: 06-11-2009, 07:08 PM
  6. [SOLVED] retrieve cell value from the cosed file
    By igorek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2005, 03:05 AM

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