How To copy Embedded Images from a Excel and paste to Folder

See more:

VB

VBA

Hi All,

Need your expert advice for my below mentioned query :-

I am receiving a task on daily basis in excel file where multiple embedded pictures inserted by sender in multiple sheets.

Now when I receive those excel files. I am opening those files one by one and manually open those embedded picture and save in 1 folder by same name as embedded in excel sheet.

I want a script that automatically copy the embedded pictures from multiple files and sheets and paste into 1 folder by their original name.

This consumes lots of time.

Can anybody suggest if its possible to save the embedded images in one folder ?

if not then any other solution ?

Thanks in advance.

Regards,

Rajender