Hello Everyone,
I have an excel file and a presentation on powepoint that has almost 100 excel objects linked from the excel, both has to be shared to other PC, but the presentation doesn't update the links in the other PC, so I adapted a macro in Powerpoint to update automaticaly the objects, it works. however, if the Excel isn't open before execute the macro the process is slow because it open and close the excel each time it find an object linked, and then, when it finished, if I try to open the excel, it close suddenly, so basicly I lost the excel file, doesn't matter the way to try to open the excel, It closes.
in the macro, the method pptPresentation.UpdateLinks is out to the for cycle. (this is one thing that I don't understand, why it open and close the excel file a hundred times if the method only run one time)
I adapted the macro from this stackoverflow.com/questions/56627694/new-drive-mapping-for-powerpoint-linked-objects-vba-solution
How can I prevent it? different to the obvious answer, have had the excel open before execute the macro.
or exist a way to recover the excel after that?
I'll appreciate your help.
Bookmarks