Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Load image from directory for custom toolbar of Excel 2000 | Excel Worksheet Functions | |||
Export image from Excel using interop | Excel Programming | |||
Convert, export, or save Word as an image file (jpg, gif, png, etc | Excel Programming | |||
Export the worksheet background image as an image file - possible? | Excel Programming | |||
Read Image From SQL Server n Export to Excel | Excel Programming |