VBA: Inserting data from Excel into Powerpoint slide

I'm absolute novice when it comes to Powerpoint and novice when it comes to Excel so bear with me please.

Using VBA I need to insert a small range from a Excel worksheet into a already existing Powerpoint presentation. In the presentation the shape where the data is shown is marked as a picture? So I need to copy the range in Excel (say B2:E10) and paste it into the presentation 'Picture'? The data in the Excel range changes everyday so the presentation must be updated everyday with the new data.

I can open/save the presentation, go to the slide and select the shape but then I get stuck. How do I paste the data as a picture into the presentation or as some other type of shape that can show the data same as it looks in Excel?

If I knew this was going to be such a schlep I would not have started at all.

The template example shape has an ID of 6 so I can select the example shape with

Please Login or Register  to view this content.

and then get the coordinates (I hope!)

Please Login or Register  to view this content.

and then delete the example shape (otherwise the new one is just pasted over the example - couldn't figure out how to replace the 'whatever it is' in the current shape)

Please Login or Register  to view this content.

I am then able to copy my range in Excel and paste it into the presentation with

Please Login or Register  to view this content.

and here everything goes to crap!

The new shape that was pasted is in the middle of the slide and it's bigger than it should be. So now I want to get it into the position where the example is on the slide and the same size as the example was on the slide.

To do this I need to get the new ID of the new shape that were pasted onto the slide and that is the selected shape but everything I tried to get that ID was in vain. Spend hours on the net and each and every example I could find did not work. I'm so tired of seeing the 'Object doesn't support this property or method' message I could crap myself.

How on God's green earth do I get the new shape ID of the selected shape on the selected slide so that I can try and work with the new shape?