Hi all,

From an Excel Master workbook I'm looking to copy the same range ("A3:AH34") from multiple excel workbooks (all have the same named worksheet, "NFR") and paste these each as an image (range includes graphs and cells populated with data, etc - i.e. the range is a dashboard view) into their own slide in a single PPT presentation starting at Slide 3 onwards. These other workbooks (8 in total) are located in different folders on a SharePoint site.

The aim is to run this macro from Excel 2010 and paste the images into PPT 2010.

An added bonus would be to include code to help centre/resize/scale the images to fit the PPT slide - I'm more than happy to play around with the sizing to ensure each image fits the slides accordingly.

An additional added bonus would be the ability to stipulate the order of the PPT slides to suit.

Anybody out there care to give this a try?