S
Samuel Sunsmith
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.
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.