Run-time error '-2147417851 (80010105)': Method 'Paste' of object 'Shapes' failed

Hi all,

I have posted about this before and also tried all different ways of fixing the problem but am still experiencing this error message. My macro takes information from a CSV file and pastes it into a pre-determined workbook. It them goes about populating charts, sending these to a pre-determined Powerpoint template.

Since updating from Excel 2010 to Excel 2013 and Excel 2013(365), I've been experiencing many issues with this inherited code. I initially tried to find if this update was the cause of this particular problem but can find nothing to say that it is - although this error has now arisen for both offices using different documents containing the code.

The line of code causing the bug is highlighted in red below (this is the first subroutine in which it occurs - the code has always used this line of code for pasting). I have edited this line to also be PPSlide.Shapes.Paste.Select to see if that was an issue, but have not used any PasteSpecial, etc functions.

Please Login or Register  to view this content.

Any help anyone can give would be truly appreciated - also happy to display more of the code if needed.

Thanks!

Originally Posted by bulina2k

Wild guessing here... Have you tried replacing
PPSlide.Shapes.Paste
with
PPSlide.Paste

I get "compile error: method or data member not found" when changing to this... Hmm...