Hi
You are rigth. You get all the files but you lose the names that they have in the worksheet.
If I also wanted the names then I'd then I'd use another method, with vba
2 options
- use a chart object to export all the pictures, saving each with the name they have in the worksheet, for ex.
or
- get the picture files and parse the xml sources for the names (in the xl->(media,drawing) subfolders)
For the first options there are lots of examples available (also here in mrexcel). If you don't know how to do it and can't find examples post back.
For the second option, you have to look into the xml sources for the workbook, open those files and parse them. If you are not used to it, maybe the first option is easier.
Does this help?