View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Find&Replace on a lot of *.doc' s via an excel macro?

If you write it.

You can get the code to do a replace in word by going to word, turning on
the macro recorder and performing the function manually. As far as creating
code to work with word, you can do that with automation. The automation
help file has examples of starting and manipulating word from another
application:

http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available



http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

--
Regards,
Tom Ogilvy

"Martyn" wrote in message
...
Need an excel macro code, that when executed will open a spesific folder
(full of *.doc files) accept a search string and a replacement from the
keyboard, search all of the documents for that string and if find it in
anywere on any of them files, replaces all, saves the changed *.docs. Is
there such a thing?
TIA


---
Outgoing mail is certified Virus Free.
(Giden posta virüssüz olarak belgelendi.)
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06.06.2004