Creating a Picture from a Shape with SavingAsPicture

[Ju4nFr4ncisco]

I am creating a macro in order to save pictures from a Shape defined within my Excel document.

Sheet2.Shapes("shape_name").SaveAsPicture "picture_name.jpg"

I guessed that would be easy, however I am getting the message "Compile Error. Argument not optional".

I appreciate you can give me a hand with this.

Best!

JF

 

[VoG]

I'm not even sure that the SaveAsPicture method exists. Maybe try this http://www.andypope.info/vba/gex.htm

 

[Ju4nFr4ncisco]

Thanks for your support VoG, however I am using the last version of Office: 2010, and I am seeing that the last review just considers the 2007 version.

Regarding your doubt that whether the method SaveAsPicture exists or not, I found it in the Excel Object Browser.

Best.

JF