Extracing embedded images from an XLS file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 10 Jan 2006 16:33 GMT

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

Reply to this Message

Dave Peterson - 10 Jan 2006 18:08 GMT

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.

> 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
[quoted text clipped - 4 lines]
> Thanks.
> -- Paul

Signature

Dave Peterson

Reply to this Message

Paul - 12 Jan 2006 00:14 GMT

Excellent, thanks.

> Try saving the workbook as a .html file.
>
[quoted text clipped - 13 lines]
>> Thanks.
>> -- Paul

Reply to this Message