title: reading an excel file, checking that format and values are correct
body: <p>I am doing a test here on reading an excel file, checking the format and values of the cells.</p>
  
  <p>I need to check these things specifically:   </p>
  
  <ul>
  <li>colA has integers  </li>
  <li>colB has integers formatted as 0001, 0012 and so forth  </li>
  <li>colD should have an integer if ColC has an 1  </li>
  <li>colE should have a 4 digit clock like 0300</li>
  </ul>
  
  <p>Whats the correct approach here?</p>
  
  <p>Now Im making functions for checking Integers like:</p>
  
  <pre><code>Int(sheet.Cells(row, col)) = sheet.Cells(row, col)     
  </code></pre>
  
  <p>This will check the integer values, but whats the best way of checking all the other things?
  I've heard about a validator object I can use.</p>
  
  <p>Anyone have any tricks on this subject?  </p>