Macro falling down at specific PPSlide.Shapes.Paste.Select

[Matcham]

Hi all,

I've been having some trouble with our company's macro for some time. Generating 30+ PP slides, it is a bit of a monster. Having just resolved reasons why it stopped working for those on Excel 2010 (we've slowly been upgrading to 2013/365), the following code has become a problem for multiple offices.

Sometimes it works for me if I have just started my computer, but this is the error message that will inevitably occur - always on this slide. Does anyone have any ideas how I can fix this? (code it falls down on highlighted in red)

Thanks for your help:

Please Login or Register  to view this content.

[LordLoki]

why do you use

Please Login or Register  to view this content.

you can remove the Select cause the object should be selected automatically after pasting it
and even if not you select the sheet and all shapes on it in the next 2 lines anyway

greets
Loki

[Matcham]

Thanks Loki,

I looked to remove them but am now receiving a Run time error 1004 - "cannot start the source application for this project"...

[LordLoki]

and the error is not happening when you put the select back?

[Matcham]

Sorry, I didn't write that clearly - I changed back but still this new problem... I think I must've saved something somewhere...

[Matcham]

This is an error some other colleagues have been experiencing for a while (relating to being upgraded to Office 2013...). I think the whole project may be due a recode.

[LordLoki]

i would guess the problem is that you not create a new instance of powerpoint instead you are looking for one

Please Login or Register  to view this content.

i would instead use

Please Login or Register  to view this content.

[Matcham]

Thanks. Actually, we have to open up a pre-saved template to export the graphs to. I posted the code here if that helps: http://www.excelforum.com/excel-prog...point-vba.html

Thank you for all of your help so far...