I have been trying to attempt this for several weeks and would really appreciate some help.
I need to write a marco in a PowerPoint presentation that will update the external links in an Excel document called "ViewableGelSchedulev3.xlsx". From my understanding, the Excel document has to be opened in order to update the links. so i tried writing code to open it and then update the links but I am getting error message 424 that an object is required at the "ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources" line. The code is below. Please help!