Hey, all. I have an Excel template users open and enter client data. A macro button saves the file to their desktop with a new client file name and opens a PowerPoint template. I have links in the PowerPoint whose source I would like to automatically update with the path and file name of the Excel file that opened it i.e. its not a fixed path and user could have more than one Exccel file opened. I have the Excel file's path and file name stored in a cell. Any help? Thanks.