Autoupdate Excel links in PowerPoint

Hi All,

I am a new user and have very low knowledge of coding VBA, but I can understand coded VBA.

I am writing a code and need help with the following:

My code is working fine if I try to open the PPT through Excel and is update the existing excel links in it. However, I want that as soon as the PPT is opened, Autoupdate function makes the excel-links as automatic, and just before closing the PPT, autoupdate function makes it manual.

Please Login or Register  to view this content.

Hi,

I have not got any reply on this but if anyone can look and help me with this. I have tried modifying the code. For some reasons, the PPT is opening fine but as soon as the code enters For loop, it stops working (pls see the updated code below).

Any help on this will be much appreciated. Thanks.

Please Login or Register  to view this content.

Yes, I get an error. Enclosed is the snapshot of the error.

Pls help.

Macro Error.JPG

Hi Mordred, would you mind looking into this.

Thanks.