Using a macro to print embedded images or documents

[DPChristman]

In my excel forms that I have created, I have my people using additional tabs to embed information (photos, receipts, statements, etc).

The finished report is then distributed.

My question is this:

Is there a macro I can use to print these statements, receipts, etc. automatically.

I know that I can just copy an paste these objects into a word document and so it that way, but some of the people who will receive these forms will not be able to figure that out.

I am looking for a simple one button process to accommodate this.

Is that possible?

 

[Jaafar Tribak]

How about adding a blank temporary worksheet, pasting the copied objects into it and printing the temporary worksheet ... Once the objects are all printed, delete the temporary worksheet.
This should be easy to do with a Macro

 

[DPChristman]

That is actually a good idea, but it won't work in this instance.
Not all forms will have embedded documents or images, and there is no way to know how many there might be in a given document.
That is one of the issues I am facing.
The other is that the users are not consistent with embedding these objects, so in some cases the object will too large or too small to print cleanly.
Since this is such a unique problem, I am going guess that I need to give up on automating this