The line highlighted is : Workbooks.Open FileName:=fileloc

fileloc is a variable name that is referenced somewhere up above that line.

It most likely looks like : set fileloc = "and the old file path here"

It should look like : set fileloc = "C:\Users\Cyberseeker\Documents\Pricelist.xlsx "


If you can't locate that line (set fileloc = "and the old file path here"), post the entire macro code here so we can review it.