This Add-In will allow you to export pictures, shapes, charts and more to image files. Available for download at http://www.andypope.info/vba/gex_addin_2007.zip
Steps and useful Hints For image extraction from excel file
How To Add, Add-ins to Excel
Step 1: Down load the Zip File from here DOWNLOAD.
Step 2: Extract Downloaded "gex_addin_2007" file (Check extracted folder for "GraphicsExporter file" )
Step 3: Open Excel File -Click Office Button- Open Excel Option
(As in Image)
Step4: In Excel Option Click "Add-Ins" , Under "Manage" -"Select Excel Add-Ins" From drop Down then Click "GO"
Step5 :In add In window select "Browse" - select Down loaded/extracted File "GraphicsExporter file" . On File selection you can see "Graphics Expoter" with a tick mark under "Add-Ins Available window. Click OK. Now You can see a Add-Ins Tab In Excel File.
click this link to know How to use the Add-in