Export image from excel file to a given directory
 

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 bold
text only . I need a macro which copies those images to a given
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 put
the first name , and the macro should increment with 1 digit ) . The
extention is not important . Could be bmp , jpg ...


More complicated is that sometimes 2 rows after the cell with bold text
only does not appear an image . There is nothing . The Macro should
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 image
from A18-A25 should be names mother3.jpg . Something like that

Very difficult indeed , but can this be done ?


--
andrei
------------------------------------------------------------------------
andrei's Profile: http://www.thecodecage.com/forumz/me...hp?userid=1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150408

Microsoft Office Help