-3

I have and excel file. in sheet1 column A is serial number column B is ID Number, Column C is image of a person, and column D is Name, now I want to export photograph to C/temp in jpg format, in the place of name i need there ID number wich is in column B, in vba, there are more then 1000 rows , pls help

arshab
  • 1

1 Answers1

0

The photographs are Shape objects. For code to export them, look at the answers to this question, Export pictures from excel file into jpg using VBA.

scenography
  • 300
  • 2
  • 6