I found the path I was looking for. It was on a different sheet to where the macro button was. I changed it accordingly, and my PC now finds the path as expected. However, my notebook doesn't yet. Strange, because they are the same file on my Onedrive.

Thanks for the help. Im learning.