Copy several graphs from Excel to Powerpoint

[M_Michael]

Hi all,

I hope you are doing well.

I'm trying to copy and paste some graphs from my Excel file to a powerpoint that already exist.

I've this code :

Please Login or Register  to view this content.

While the first graph get copied properly, I obtain this error (where the text is written in red in my code) : "Error - Invalid request. To select a shape its view must be active".

Do you have an idea on how I can solve this?

Thank you very much.

[nilem]

Hi Michael.M,
maybe so

Please Login or Register  to view this content.

[M_Michael]

Hi Nilem,

Thanks for your answer. I tried but I still obtain the same error.

[dflak]

See if this can help you. https://www.excelforum.com/tips-and-...rom-excel.html

[nilem]

Please Login or Register  to view this content.

[M_Michael]

Please Login or Register  to view this content.

Hi Nilem,

Thanks it did work perfectly. Yet, the part now in green (place on the slide) does not work. The code is executed without a block but it's like orders the macro does not follow ? Would you know the reason?

In addition, for the line in blue, should I increase the counter for each new chart ? i.e. next chart --> .Shapes(2).Select ?

Thanks !

@dflak : Thanks for your solution, I will keep it aside for the moment since it seems I'm on the good way with Nilem's solution ! But should you have any idea for my other challenges listed above, I'd be very happy to read your solution !

Thanks !!

[nilem]

Hm, it works for me. But try this

Please Login or Register  to view this content.

The new chart for slide #6 will be Shapes(2), than Shapes(3), etc.
For slide #7, the numbering is repeated i.e. Shapes(1), Shapes(2), etc.

[M_Michael]

Hi Nilem,

So I tried and it indeed works but not for the desired shape ! There are pre-existing shapes on the slide like titles, page numbers, dates (inputed as textboxes) but it recognizes it as shapes. For the next people who have this issue, you can use the name selection instead of the number one, i.e. : .Shapes("Year to date").Select so that it selects the right shape !

A big thank you to Nilem and dflak for their support !

Michael