title: Search all columns in an excel column and check value against file name in folder to see if exists?
body: <p>I have a folder with .txt files:</p>
  
  <pre><code>\\uksh000-file06\SharedAreas\1.0 Hewden Public\NS\Approval
  </code></pre>
  
  <p>Each text file has a random name like so:</p>
  
  <pre><code>NS123SHS.txt
  NSg234eH.txt
  NSds3461.txt
  </code></pre>
  
  <p>Most of the files file names (minus the extenstion .txt) are in my excel sheet in column c.</p>
  
  <pre><code>NS123SHS
  NSds3461
  </code></pre>
  
  <p>I am trying to scan column c to check if the filename is found in my folder directory and if yes show a message saying found, else show a message saying not found.</p>
  
  <p>So far all I've been able to figure out is how to scan my column for  specific value, which i define, however I want to be able to scan the entire column, and compare each value to see if it exists in my folder?</p>
  
  <p>Can someone please show me how I might do this please? Thanks</p>
  
  <pre><code>Private Sub Workbook_Open()
  
  Dim FindString As String
  Dim Rng As Range
  FindString = "NSds3461"
  If Trim(FindString) &lt;&gt; "" Then
      With Sheets("Home").Range("C:C") 'searches all of column A
          Set Rng = .Find(What:=FindString, _
                          After:=.Cells(.Cells.Count), _
                          LookIn:=xlValues, _
                          LookAt:=xlWhole, _
                          SearchOrder:=xlByRows, _
                          SearchDirection:=xlNext, _
                          MatchCase:=False)
          If Not Rng Is Nothing Then
               MsgBox "found" 'value not found
          Else
              MsgBox "Reference Not Found" 'value not found
          End If
      End With
  
  End If
  </code></pre>