PDA

View Full Version : Exporting Camera Snapshots



dave777
12-20-2015, 02:43 PM
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

p45cal
12-20-2015, 05:17 PM
please supply links to cross posts