Comparing Two Excel Workbooks & Output any differences

[Khurrambilal01]

Hi experts,

I am new to the forum, Nice to see a good community with so many experts of Excel programming & Macros,

I want to compare two excel workbooks with multiple worksheets each having alphabets, numbers, texts in old file and new file.
The names and order of sheets in old and new file is always the same just some data changes everyday and i want to check on daily basis which data has changed or there is no data changed at all.

Below is the code that i am currently using and i have taken this code from external internet content,
The problem is when i run this code it says unable to find file "olddata.xls" please check the path or correct the filename.

Can you please help me to complete this operation?

Please Login or Register  to view this content.

[6StringJazzer]

Is the file with the macro in a different folder than the files you are comparing? If so you need to give the full path name for the files you want to open, similar to this:

Please Login or Register  to view this content.

It is usually a good idea to use the full path names regardless, to avoid any ambiguity about what's going on.

[Khurrambilal01]

Is the file with the macro in a different folder than the files you are comparing? If so you need to give the full path name for the files you want to open, similar to this:

Please Login or Register  to view this content.

It is usually a good idea to use the full path names regardless, to avoid any ambiguity about what's going on.

Thanks for your kind support, The files were't located in Macro's folder,I would try this way.
Cheers.