Never mind I got it. Its; If WB.Name = ("Workbook 2.xls") Or WB.Name =
File1.Name Then

Thanks a a lot for the help.

"Ronbo" wrote:

It still does not work with .xls and spelled correctly. Any other ideas?


"Die_Another_Day" wrote:

Oops. Add .xls on the end of Workbook 2 and make sure that it's spelled
correctly

Die_Another_Day