The new files need to exist for this to work. If the files don't exist, Excel will open the dialogue box to help you locate an existing file. if the files exist, then the find/replace works as expected.