title: Checking if filenames contain a string
body: <p>In my project,I have a product list in first column on a excel sheet and I regularly download product images from a website and than store them in a Folder differently named for every project. When downloading process is over, I delete the image files which are unnecessary.</p>
  
  <p>After deleting process , I want to know how many image left for every product on folder.</p>
  
  <p>Examples:</p>
  
  <p>My list of product name in first column >>>
  <a href="https://i.stack.imgur.com/k020J.png" rel="nofollow noreferrer">click for image</a> </p>
  
  <p>My image folder >>> <a href="https://i.stack.imgur.com/OIiKU.png" rel="nofollow noreferrer">click for image</a></p>
  
  <p>What I want is the number of image on a folder for every product >>>
  <a href="https://i.stack.imgur.com/bMbaV.png" rel="nofollow noreferrer">click for image</a></p>
  
  <p>If I make excel formula to write the number of images for every product on second column ,next to corresponding product name cell, I will able to easily see any lack of image for any product. After that, I will report the list of products which have zero image.</p>
  
  <p>All names of images consist of two parts "productname" and "_*", * is a number. Because product name is not the same as name of image files, values in number of image column is must be the number of image whose name contain product name.</p>
  
  <p>Does it doable or not? I have very basic knowledge of VBA.</p>
  
  <p><strong>Here what I get when I try to use method of</strong> <strong>@Miguel_Ryu</strong></p>
  
  <p>Function I wrote >>> <a href="https://i.stack.imgur.com/BNopc.png" rel="nofollow noreferrer">click here</a></p>
  
  <p>My Folder >>> <a href="https://i.stack.imgur.com/BRNBi.png" rel="nofollow noreferrer">click here</a></p>
  
  <p>Error I got >>> <a href="https://i.stack.imgur.com/hheeI.png" rel="nofollow noreferrer">click here</a></p>
  
  <p>Module >>><a href="https://i.stack.imgur.com/eVXSm.png" rel="nofollow noreferrer">click here</a></p>