Thank you for the example. What I need to insert is the link to a file that changes name every day. More like C:\Users\Desktop\DailyReport_07232021.xlsx
“07232021” will change depending on today’s date. I have also saved this link in a separate file, like cell A1 in C:\Users\Desktop\MasterFile.xlsx