Hi,
I need a code that will save all pictures in a sheet, picture 1 will be in B2 with filename in C2 e.g name & ".jpg". Picture 2 in B3 etc..
I need it to check if theres a picture in B2, B3 etc..
I need it to check if file path already exists, if it does then next loop otherwise save in folder.
Once saved I need to delete entirerow that it was in.
Thanks,
In very basic terms I think.. but i want to be careful with entirerowdelete as theres formulas in C and D.
For each X in Rng
If X HAS PICTURE IN then check if filepath exists, if yes then kill else save picture as (X,1).value
entirerow.delete
else
next X
end if
Next X
I need a code that will save all pictures in a sheet, picture 1 will be in B2 with filename in C2 e.g name & ".jpg". Picture 2 in B3 etc..
I need it to check if theres a picture in B2, B3 etc..
I need it to check if file path already exists, if it does then next loop otherwise save in folder.
Once saved I need to delete entirerow that it was in.
Thanks,
In very basic terms I think.. but i want to be careful with entirerowdelete as theres formulas in C and D.
For each X in Rng
If X HAS PICTURE IN then check if filepath exists, if yes then kill else save picture as (X,1).value
entirerow.delete
else
next X
end if
Next X
Last edited: