Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfering data from a .pdf file to word and then to excel | Excel Worksheet Functions | |||
Automatically Transfering Data from Excel to Word file | Excel Discussion (Misc queries) | |||
Transfering one cell of word to excel | Excel Discussion (Misc queries) | |||
Excel data not transfering to Word. Colums are expanded. | New Users to Excel | |||
transfering info from one sheet to another based on info being transferred | Excel Programming |