View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default Help with transfering info from Excel to Word

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
-----Original Message-----
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


.