Excel to PPT - VBA no longer working with 2013

[Jissenka]

Hi,
Hoping someone could help, I have an excel workbook with several tabs/worksheets. and I found some VBA that converted a range on each worksheet into a shape a pasted it into a separate slide in a new work book.

This however no longer works since we have moved to Office 2013.

When the debugging screen comes up it highlights this row in step 7 - PPSlide.Shapes.Paste.Select

Please Login or Register  to view this content.

I hope someone can help.
Thank you in advance.

Brad

[Jissenka]

Hi,
I may have found a solution myself.

I removed the .select from the end of the problem line. (PPSlide.Shapes.Paste.Select)

It is working so far

If anyone else has a confirmation or can see any issues with this please let me know.

Cheers,
Brad


EDIT: I have marked this as solved, thank you to all that viewed.