I am trying to print embedded word documents with an excel function. In my sheet I have a button that I press, in the sheet, that prints the information, see code below. However, this does not bring embedded word documents (When they are shown as icons). I need them to be shown as icons.

So, i need to open, print and close each embedded word document in the spread sheet. If this helps, the word documents will only be in the worksheet "Variable Expense Key"

Example:
I have a word document embedded into excel and I want that word document to print when I use my print function. Here is the function:

Please Login or Register  to view this content.
As is, the function is only printing certain worksheets. A few of these worksheets have embedded word documents. I can open the word document and manually print it. However, with what we are using this for that will take too much time. I am looking for a way to stream line the process.

If that is not clear enough, let me know I can try and explain more.