find and replace answer word?
Hi
I have two large file in openoffice calc and openoffice writer. And have some dictionary word in openoffice clac file without answer, but in openoffice writer file i have words with answers.
Now i want an script or macro's for finding first word from openoffice calc file and search it in openoffice writer file,when find it, copy means to opposite same word in openoffice clac cell file, and continue for finishing words in clac file to end file.
like:
calc file
words means(must replace from writer file)
AA --
BB --
CC --
DD --
EE --
FF --
openoffice writer file:
words means
AA aa
BB bb
CC cc
DD dd
EE ee
after succeeded script or any programs we must have clac file like this:
words means (find and replace from writer file)
AA aa
BB bb
CC cc
DD dd
EE ee
I want copy and paste all word from writer file to calc file in one sheet and then run your script you write for me.
thanks a lot
|