title: Changing Worksheet Data in Embedded Excel Worksheet in MS Word
body: <p>I've been beating my head up against this for way too long and I cannot seem to find any posts on this specific issue:</p>
  
  <p>I have a MS Word 2010 Document that has an embedded Excel worksheet, not linked.  My ultimate goal is to modify the data on that worksheet from MS Access, but for now, I'm just trying to figure out how to reference that underlying worksheet.</p>
  
  <p>I've been able to do it with a Chart, but not an embedded worksheet.</p>
  
  <p>I can locate the object:</p>
  
  <pre><code>me.Shapes(1)
  </code></pre>
  
  <p>and even get the alternate text from it:</p>
  
  <pre><code>debug.print me.Shapes(1).AlternativeText
  </code></pre>
  
  <p>but cannot figure out how to get to the underlying worksheet.  With a chart, I could simply reference the <code>me.Shapes(1).Chart.ChartData</code> and on from there, but there isn't a predefined object for the worksheet itself.</p>
  
  <p>Can anyone help me?  I would be most greatful! :-)</p>