title: Copy Word content into Excel spreadsheet using Excel VBA
body: <p>I have a set of word documents which contains evaluation forms.  I can manually copy and paste these along with their formatting into an excel spreadsheet, but I am interested in automating this using VBA since I have about 400 of these.</p>
  
  <p>How can I open each of these and copy and paste the data into excel while retaining all of the formatting?</p>