I am not sure why this code does not worked because I used a similar variation in another project and it worked. I checked the file location of the file and path needing to be opened and its correct. Not sure why its not finding the workbook. The error occurs on the
Set wb =...