Export a picture from Excel?!?

[steveroberts]

I have a set of workbooks, each containing three sheets, each of these sheets with a different picture. The idea is that the pictures are imported to a template worksheet (in a stand alone book) based on the value of a variable. I can open the 'picture' books, copy the pictures and paste them into the template in the right place and to the right size. Everything looks great and works well but.....

...then I print. The pictures grow!

So, I want to put these pictures into an image control which won't grow when it prints.

But the trouble with this is that I can't export the pictures from Excel, so that the path of the image can be supplied to LoadPicture().

Is there a way of exporting a picture from a workbook (in a simillar way to chart object's Export method)?

 

[ChrisBurch]

Did you get any solutions to this problem? I've got a similar scenario to handle.

Regards

Chris

It worked yesterday.
It doesn't work today.
That's Windows!