Export image from excel file to a given directory

A

andrei

A have an excel sheet with information and also with images

All images which i am interested in are 2 rows after a cell with bol
text only . I need a macro which copies those images to a give
directory . And the images should have a given name ( actually
something like mother1 , mother2 ... but not necessary from 1 to n
could also be from mother1000 to mother1200 , i should be able to pu
the first name , and the macro should increment with 1 digit ) . Th
extention is not important . Could be bmp , jpg ...


More complicated is that sometimes 2 rows after the cell with bold tex
only does not appear an image . There is nothing . The Macro shoul
take into consideration that . An example should be better

A1: bold text
A2 : nothing
A3-A7 : an image

A10 : bold text
A11 : nothing
A12 : nothing

A16: bold text
A17: nothing
A18-A25: an image

The image from A3-A7 should be named mother1.jpg (or bmp) and the imag
from A18-A25 should be names mother3.jpg . Something like that

Very difficult indeed , but can this be done
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top