Update content of PowerPoint using VBA

Hi!

I want to update my PowerPoint content and thus I create this code which links the columns A, B, C and D to the content inside my PowerPoint. The problem is whoever uses my code will then have to insert text box to the content in the PowerPoint which they want to edit. Here's my code:

Please Login or Register  to view this content.

Can I know how we can avoid as such we have to insert every new text box every single time? Any idea?

In addition, I always get this one error that says run time error: slides (unknown member): bad argument type. Expected collection index (string or integer). May I know why?

Originally Posted by MarvinP

Hi ell,

Are you inserting a LINK to your workbook or something else?
Here are instructions that I'd follow.
http://www.indezine.com/products/pow...ts-in-ppt.html
but it really sounds like you want to LINK the excel into your Power Point...
https://blogs.msdn.microsoft.com/mvp...nd-dashboards/

I wonder if this Link feature was available with Mac 2013 version of Excel.?

Hi Marvin, no I was not inserting a link. More like updating the PowerPoint with new content. But I would like to insert an editable form which can be replicated via PPPasteDefault (to allow editing of range inside the PowerPoint) but I'm not sure how to do it.

I have tried to apply PPPasteDefault into the code but it shows an error. You can see the code I have tried to mend as stated in the post above which has been colored with red.

Solved here: https://www.excelforum.com/excel-pro...able-form.html