title: Excel macro if file exist
body: <p>So like the topic title says, i am looking for some help with a macro.
  I need it for my job so every time a clients backup is executed he sends a mail to a mailbox and these mails are exported in the folder.
  This is the mail format:</p>
  
  <blockquote>
    <p>Backup Rapport Success Clients name File Backup Set Taak 2012-10-23 (20 30)</p>
  </blockquote>
  
  <p>The macro's needs to do a few things :</p>
  
  <ul>
  <li>Extract the name of the client</li>
  <li>extract or the backup whas SUccess or failed or missed</li>
  <li>And write the success or failed message in the right cell </li>
  </ul>
  
  <p>Is this even possible?</p>
  
  <pre><code>Public Function FileFolderExists(strFullPath As String) As Boolean
  'Author       : Ken Puls (www.excelguru.ca)
  'Macro Purpose: Check if a file or folder exists
      On Error GoTo EarlyExit
      If Not Dir(strFullPath, vbDirectory) = vbNullString Then FileFolderExists = True
  
  EarlyExit:
      On Error GoTo 0
  End Function
  
  Public Sub TestFolderExistence()
  'Author       : Ken Puls (www.excelguru.ca)
  'Macro Purpose: Test if directory exists
      If FileFolderExists("c:\test") Then
          MsgBox "Folder exists!"
      Else
          MsgBox "Folder does not exist!"
      End If
  End Sub
  </code></pre>