Help with transfering info from Excel to Word

  • Thread starter Thread starter Luc Dansereau
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word save as Filename.doc.doc 4
New to VBA -> Setting Excel Columns to Strings 3
Bold words in document 1
Saving a Word document as PDF from en Excel macro 2
More on VBE syntax line question 4
Copy from Excel to Word 2
Mail merge to Word from Access 2000 1
Tranfer data from Excel to word (Docx) via VBA in Excel 5

Back
Top