Controlling Excel from Word

Can anybody help me to solve this issue?

I have lots of word document files for proofreading and I would like to keep a register in excel file for the completed documents. My excel file ‘myexcel.xls’ format should be like this.

Sl. No. Word File Name Editing Proofreading
1. Doc01.doc 1 1
2. Doc02.doc 1 1
3. Doc02.doc 1 1
…..
…..

I need 3 macros to be written for Word for automatically updating the excel file within the word document.

FileRegisterMacro, which is for inserting the word filename in my excel file without having duplicate entry. If possible this macro should automatically fill the Sl. No. column also.

EditOverMacro, which is for inserting ‘1’ in the Editing column of the excel sheet as against the corresponding Word File name entry of the row

ProffOverMacro, which is for inserting ‘1’ in the Proofreading column of the excel sheet as against the corresponding Word File Name entry of the row

For Example if I run FileRegisterMacro within the word document named “Doc03.doc” immediately the program should open and check the myexcel.xls and insert “Doc03.doc” in the ‘Word File Name’ column if it is not found there. If the name already exists there no need to do anything with this macro.

If I run EditOverMarco within the word document named “Doc03.doc”, this macro should search the entry named “Doc03.doc” in the excel sheet and it should put ‘1’ in the corresponding column (“Editing”) of that particular row.

In the similar manner it should work for the ProffOverMacro.

Please help me.