The copying will solve the problem definitely. Actually i am getting two excel sheets daily which are needs to be compared. I am copying both the sheets in one excel file and pasting the macro in the same excel file and then i am running the macro to get the compared result. Its pretty hectic.So is there any way by which i can just give the path name for 2 files and get the compared result.