Hi,
I have a worksheet that loops through values in an array to calculate results to a summary worksheet elsewhere.
All that works fine and the summary worksheet/dashboard is a combination of charts and cell values.
I would like to make a screen capture of the summary page results for each loop iteration and save it to a JPEG in a specified folder or as an alternative, paste to PowerPoint iteratively in a new slide.
I've tried a few examples that were listed earlier here or elsewhere on the web, but nothing works.
If anyone can point me to an existing thread or a way to do it, it is greatly appreciated! Thanks.
I have a worksheet that loops through values in an array to calculate results to a summary worksheet elsewhere.
All that works fine and the summary worksheet/dashboard is a combination of charts and cell values.
I would like to make a screen capture of the summary page results for each loop iteration and save it to a JPEG in a specified folder or as an alternative, paste to PowerPoint iteratively in a new slide.
I've tried a few examples that were listed earlier here or elsewhere on the web, but nothing works.
If anyone can point me to an existing thread or a way to do it, it is greatly appreciated! Thanks.