Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel sheet with the following columns

  1. Product ID
  2. Product Name
  3. Images

Images are placed on the worksheet but not in any cell. I want to extract the images as files (jpg, png, gif, etc) and I also want them to be named according to values in the "Product Name" column.

So the 1st image will be named according to the 1st value in "Product Name" Column, the second according to the second etc.

As a workaround, I'm able solve the extracting part by saving the Excel sheet as a HTML document, which also saves the images I want. However I'm unable to control the image names: Excel sets a pre-defined name, like image1.jpg, image2.jpg etc.

So, what I want is

if the "product name" column has the following values ;

  1. product1
  2. product2
  3. product3

I should have images with the name

  1. product1.jpg
  2. product2.jpg
  3. product3.jpg
share|improve this question
I'm afraid this is not clear enough. Excel cells can contain values or formulas. They cannot contain images. You can insert images into a worksheet, but they are managed on a separate layer, not "in" a cell. An image object can be positioned relative to a cell. You may want to provide a sample file and detail your requirements some more. – teylyn May 31 '13 at 11:47
I agree with @teylyn because Excel is not good for managing images. If you are creating this spreadsheet you may want to consider using links to the images or use a different application. If you just trying to extract the data out of it, that is different. Please clarify. – CharlieRB May 31 '13 at 11:50
You can do this with VBA will assign a name based upon a cell. However, your worksheet will need to be organized in such a manner that it can associate the correct image with the appropriate cell for a label. – dav May 31 '13 at 18:40
I have edited the Question accordingly, basically I only want to extract the images as files and at the same time I also want to control the file names according to the values in "Product Name" Column. – TDsouza Jun 1 '13 at 5:51

You must log in to answer this question.

Browse other questions tagged .