title: show a message box containing a list of all files in a directory except one?
body: <p>I am trying to bring up a message box in excel showing a list of all the files in a directory like so:</p>
  
  <pre><code> Dim StrFile As String
      StrFile = Dir("S:\Tasks\Tenders\" &amp; Range("M" &amp; ActiveCell.Row).Value &amp; "\" &amp; Range("Z" &amp; ActiveCell.Row).Value &amp; "\*.*")
      StrFile = Dir
          MsgBox StrFile
  </code></pre>
  
  <p>the problem  have at the moment is this only shows one file out of a possible 20.</p>
  
  <p>I am trying to get all the files in the folder listed in the message box like so:</p>
  
  <pre><code>File 1
  File 2
  File 3
  etc
  </code></pre>
  
  <p>I also have a file called log.txt which I want to exclude from being listed.</p>
  
  <p>Please can someone show me the best way to do this? Thanks in advance</p>