Charts and ranges from multiple Excel sheets to PowerPoint presentation multiple pages

Hi,

I have attached a sample excel file that contains some ranges and charts and a sample ppt that reflects the desired results. Basically, I have multiple charts and ranges on around 20 sheets that needs to be set up in a presentation. Multiple worksheets contains a number of charts. Many of them should be added on a single page, but there are some worksheets that contain a number of charts(based on a single range that needs to be added as well) that should be added on a single page(slide 8). Also, If posible, it should open an existing presentation and paste them to that.

All of them should be pasted as pictures in the ppt presentation. Is it doable via VBA? I've searched some threads about it, but I cannot figure it out on my self.
Any help will be greatly appreciated.

Thank you!

In case someone is looking for a solution, I managed to resolve 90% of my query using the below 2 macros. Does anyone know how can I chose the sizes of the range copied as a picture(Height and Width) as well as the positioning into the ppt page(at the bottom)?

To copy charts:

Please Login or Register  to view this content.

Code to copy the ranges as named ranges:

Please Login or Register  to view this content.