Hi All,

I have asked the same question in other forum. Please find the link below

http://chandoo.org/forum/threads/met...sfailed.35031/

Hi All,

I am working on automation where I am exporting the charts from excel to powerpoint.
When I run the code by step by step it is working perfectly. However when I run the sub command I am getting the runtime error stating 'Method 'item'of the object 'shapes'failed'. I tried with couple of ways however I am not able to fix the issue. I have grouped all the charts and objects and named it as 1 ,2,3 etc. I need to keep the source and formatting hence I preferred

ppapp.CommandBars.ExecuteMso ("PasteSourceFormatting")


I am not sure what is causing the issue. Please assist.

code below
Please Login or Register  to view this content.