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:

Sub CbPrintOuts()
Worksheets(Array("Notes", "Professionals Statement", "Variable Expense Key", "Summary - All", "Causation - All", "Revenue - All", "Profit - All" _
, "07,08,09 calculation", "08,09 calculation", "2009 calculation", "Profit Database - 2007", "Profit Database - 2008", "Profit Database - 2009", "Profit Database 2010" _
, "2011 Revenue", "Payroll Calculation", "Payroll 2007", "Payroll 2008", "Payroll 2009", "Payroll 2010")).PrintOut
Worksheets("Index").Activate
End Sub
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.