title: Extract Data from Word Document to an Excel SpreadSheet
body: <p>I have a requirement to extract a value from a word document on a daily basis and write it to an excel workbook.  I currently do this manually and it is border line regarding the most efficient method for me</p>
  
  <ol>
  <li>Using Excel file create a vba script and add any word document references.</li>
  </ol>
  
  <p>2 Using the word navigate to the table “9. STOCKS...” (extracted example below – Appendix A) and read the Diesel (ltrs) daily usage highlighted in red. </p>
  
  <p>3.Write this value to a spreadsheet cell.</p>
  
  <ol start="4">
  <li>The date for this value is also key but it held in another part of the word document (Appendix B).  Dates are also in the file name but we trust the internal value more than the word document name.  With knowledge from points 3 and 4 extract the associated date to an adjacent spreadsheet cell.</li>
  </ol>
  
  <p>The table is displayed below, because of the formatting I'm not able to send you the exact table but I will be able to send the values of it.</p>
  
  <p>9.STOCKS (As of 00:01 hrs on Day of report issue).
  Stock Held
  Daily Usage
  Minimum Stock</p>
  
  <p>Diesel  (ltrs)<br>
  390436
  <strong>15012</strong>
  25000</p>
  
  <p>Nitrogen (mm)<br>
  35
  1
  19
  Champion  1033 (totes)<br>
  15
  1
  4
  Nexguard (Boilers)
  4<br>
  0.25
  4 x 200 ltrs</p>
  
  <p>Appendix B:
  Beatrice Period of Report:
  00:01 – 24:00 10th  August 2010</p>
  
  <p>If you have any doubts regarding my question please get back to me, I appreciate your efforts and wanted to thanks in advance  </p>