Multiple find and replace from Glossary sheet to the active sheet

Dear All

I have searched the following threads in the forum and yet to solve my issue.
http://www.excelforum.com/excel-prog...d-replace.html
http://www.excelforum.com/excel-work...at-a-time.html
http://www.excelforum.com/excel-prog...d-replace.html
http://www.excelforum.com/excel-prog...d-replace.html
http://www.excelforum.com/excel-prog...d-replace.html
http://www.excelforum.com/excel-prog...-in-excel.html

I have 2 excel files.
File1: "To find and replace.xls"
File2: "Glossary.xls"
The macro is in file2 "Glossary.xls" and should be run from this file

The file "Glossary.xls" has "find phrase" in Column A and "replace phrase" in column B.
The macro is in "Module1" of this file.

Now,
I need to select a phrase in the file "To find and replace.xls"
(This file has multiple sheets, and text phrase is in cells, merged cells, text boxes and comments.)
then go to the file "Glossary.xls",
check if the phrase is present in Column A,
and if it is present then take the value in Column B of the same row,
and replace it in the file "To find and replace.xls"

I am able to achieve this "Find and replace" in the same sheet with the source in "Sheet1" and Glossary in "Sheet2". I am attached the following files
File1: "To find and replace.xls"
File2: "Glossary.xls"

Glossary.xls

To Find and Replace.xls

Kindly help me to make the find and replace in the file "To find and replace.xls" from the file "Glossary.xls"

Thanks in advance
Chandru

Dear All

Just one more point that I forget to mention.
I would prefer not to hard code the File1: "To find and replace.xls" , and instead this shall be the active document because I have number of files to change.

Regards
Chandru