delete entire row with condition

Hi,
I am looking for the macro that do the things mentioned below

If column B of 1.xls matches with sheet2 of column B of 5.xls then delete that entire row of 1.xls

Note there may be a chance that 5.xlsx sheet2 may be a blank sheet in that case do nothing & no error msg should come
sheet name can be anything in both the files
macro will be placed in macro.xlsm so the path should be hardcoded in the macro for both the files so that i can change it as per my needs


Thnx For the Help

I was unable to code macro for this Sir