Help with transfering info from Excel to Word

L

Luc Dansereau

Hi,

Is it possible, using VB in Excel to :
1- Open "Doc.doc" in Microsoft Word
2- Perform a "search and replace" function in "Doc.doc" using range
"oldText" and "newText" in Excel to give parameters to that function
3- Save "Doc.doc" in a different folderusing a different name "Doc2.doc"

Thanks very much for your help

Luc
 
G

Gjones

Hi Luc;

Go into VBA and look in help at CreatObject. It will give
you a call on how to get into Word and the specific
docuemtent. Then you can create a macro in Word or
execute it from Excel to do the search and replace.

Thanks,

Greg
 
Top