Extracing embedded images from an XLS file

[Paul]

I have a customer who manually maintains a catalog of products in an Excel
file, one item per row, with a picture of the item embedded into the first
cell on each row. They want to webify this catalog, so I need to pull out
the images. Is there a utility or method (using VBA, etc.) to automatically
extract all the embedded images into separate BMP or JPG files?

Thanks.
-- Paul

 

[Dave Peterson]

Try saving the workbook as a .html file.

Then you'll see another folder under the folder that holds that file that
contains all the pictures.

 

[Paul]

Excellent, thanks.

Try saving the workbook as a .html file.

Then you'll see another folder under the folder that holds that file that
contains all the pictures.