Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Help with transfering info from Excel to Word

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   Report Post  
Posted to microsoft.public.excel.programming
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


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfering data from a .pdf file to word and then to excel David Bateman Excel Worksheet Functions 1 February 19th 10 10:03 PM
Automatically Transfering Data from Excel to Word file Ra Excel Discussion (Misc queries) 3 April 8th 09 01:20 PM
Transfering one cell of word to excel WINDMILL Excel Discussion (Misc queries) 2 November 20th 08 04:44 PM
Excel data not transfering to Word. Colums are expanded. carolsue1313 New Users to Excel 2 June 24th 05 08:16 PM
transfering info from one sheet to another based on info being transferred CClarke Excel Programming 0 January 14th 04 08:04 PM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"