Controlling Excel from Word

[nescomanoj]

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.

 

[Chip Orange]

I see all your requirements, but what is your question?

Can it be done? Sure, no problem, but you'll need to learn VBA to do it.

Is *way* too complex for someone to give you the entire suite of macros here
as an answer.

Chip