Manipulating Embedded Excel Spdsht / Chart / Macro from Word 2007   

I have a user form that fires at Document_Open. This form collects client 
data and request types which are used to replace tags within the document.  

Some of these tags are contained in an embedded Excel workbook. I have been 
unable to find any information on how to control and manipulate data within 
an Excel workbook embedded in a Word document (both are 2007).

Also is it possible to have a macro in the embedded Excel workbook that the 
user can execute via a button click or that can be executed from Word 
(something to the effect of Excel.Run Module.Macro) that would revise the 
“look” a chart in the embedded workbook and make it visible? I’ve been able 
to do this once when creating the embedded workbook but subsequent executions 
(after closing and re-opening the Word document) fail.

Thoughts?

Thank you in advance for your time and consideration.

date: Mon, 6 Oct 2008 13:01:01 -0700   author:   Samuel Sunsmith