Hello,

I am working on a solution where I need to copy several rows from an Excel range to PowerPoint.

Each row needs to go to a different slide and has to be pasted as a msoAutoShape (to preserve a link which is in the copy range).

The code is reasonably straightforward:

Please Login or Register  to view this content.

This goes well most of the time, but sometimes, the range gets pasted as an Excel object, instead of a msoAutoShape, which causes the formatting to go wrong.
It is not every time that the same row goes wrong. It frustrates me that there are random mistakes. Possibly caused by network delay?

I have attached the workbook and PPT files as a link: https://www.nedcom.nl/DemoExcelToPPT.zip and am very curious who can shed some light on this mystery and if I can do something to prevent this from happening permanently.

Grtz Bart