Exporting Camera Snapshots

Hello friends!
I have a file with multiple CAMERA snapshots all pointing to various charts of a workbook. I need to be able to save these snapshots with their proper names as PNG or JPEG files. I wonder if this can be done with VBA? I can save all snapshots in good quality by saving the sheet as a single WEBPAGE – but this time the charts are saved with seemingly random names like – “camera-pics_9469_image005.png” or ‘img001.png”.
I have attached the sample workbook,
DHello friends!
I have a file with multiple CAMERA snapshots all pointing to various charts of a workbook. I need to be able to save these snapshots with their proper names as PNG or JPEG files. I wonder if this can be done with VBA? I can save all snapshots in good quality by saving the sheet as a single WEBPAGE – but this time the charts are saved with seemingly random names like – “camera-pics_9469_image005.png” or ‘img001.png”.
I have attached the sample workbook,
D

please supply links to cross posts