In an excel sheet there are 3 pics and in other sheet (same workbook) there are 2 pics, now I want to extract the all the pictures from this workbook to a folder with these rules naming rules:
1. first pictures of sheet 1 will be saved as "A1-A.jpg". Similarly, 2nd picture of same sheet will be "A1-B" and so on.
2. Similarly, Sheet 2 naming will be the A1 cell of sheet 2 plus A and for 2nd picture of sheet 2 it will be A1-B, and so on forth with other sheets,
So in short, I have to extract pics from each sheet and name each picture from its cell ref + A, B or C respectively.
Its challenging but can we have a macro for it? Thanks a lot!
1. first pictures of sheet 1 will be saved as "A1-A.jpg". Similarly, 2nd picture of same sheet will be "A1-B" and so on.
2. Similarly, Sheet 2 naming will be the A1 cell of sheet 2 plus A and for 2nd picture of sheet 2 it will be A1-B, and so on forth with other sheets,
So in short, I have to extract pics from each sheet and name each picture from its cell ref + A, B or C respectively.
Its challenging but can we have a macro for it? Thanks a lot!
