Embedding Documents in PowerPoint using VBA

This is my first post on the excel forum, and I like to think I am good at excel, but this is alluding me. I am trying to automate the metrics I generate, and I've managed to get the excel raw data manipulation down and the excel charts to ppt down, but I want more automation, so I'm trying to added a few embedded files as well.

Please Login or Register  to view this content.

I will probably delete the current icons that are there and replace the iconindex with a 1 assuming it works with bit of code.

variant of the addoleobject

Please Login or Register  to view this content.

I tried to follow the workbooks.worksheets logic and the examples i've found and it looks right, but i get the error: '-214767259 (80004005) Method 'AddOLEObject' of object 'Shapes' failed. Any help to fix my code or simpler method of embedding objects will be greatly appreciated.