Excel to Powerpoint export

I am trying to re use the following code to transfer all my excel 2007 charts to a powerpoint presentation. The problem with the existing code was it could not transfer charts that are moved as sheet itself.
For that I have introduced a new loop to capture those charts (marked in red). I am assuming that I am not using right object.

Please Login or Register  to view this content.

I apolosize for my last post, in which I didn't wrapped my code in tags


Please advice.

Thanks,
Webbug


Full code

Please Login or Register  to view this content.

I have not had time to work up an example. If you posted a sample xls, it would help us help you. Until then, this thread might be of some help. http://www.excelforum.com/excel-prog...nt-slides.html

Dear Sir,

Thank you for helping me.
I have attached an excel with some Q&D charts.

Thanks,
Webbug

Thank you.

Its is working now...

webbug

I will really appreciate if you could also suggest appropriate modification as to

if there are any active presentation available, code add charts on that, if not it will create a new one. I have tried using the following code for activating any existing ppt.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for your great helps.

Webbug

Many Thanks..

Webbug..

Here is a GetObject method to add to an existing Presentation or add to a new one if not.

Please Login or Register  to view this content.