加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

WORD VBA 查找并替换

(2010-03-27 23:40:50)
标签:

移动宽带

it

分类: 移动、宽带__博客张凯_unikran
Sub Macro1()
 Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
   
    x1 = "cell"
    x2 = "小区"
   '下一步就是要想办法从文本文件或者EXCEL文件中获得不断变化的x1,x2 然后将整篇文章翻译成汉语
 
    Call s2(x1, x2)
  
      
 
   
End Sub
Sub s1(x1, x2)
       With Selection.Find
        .Text = x1
        .Replacement.Text = x2
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchByte = True
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
  Selection.Find.Execute Replace:=wdReplaceAll
  '查找并替换
End Sub

Sub s2(x1, x2)
Call s1(x1, x2)
  
Call s1(x2 + "s", x2)
  
Call s1(x2 + "es", x2)
'名词复数
End Sub

=====================
'第二种:  原文不懂,仅仅加入带括号的汉字。。
Sub Macro1()
 Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
  
    x1 = "cell"
    x2 = "小区"
 
 
    Call s2(x1, x2)
 
     
 
  
End Sub
Sub s1(x1, x2)
       With Selection.Find
        .Text = x1
        .Replacement.Text = x2
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchByte = True
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
  Selection.Find.Execute Replace:=wdReplaceAll
  '查找并替换
End Sub

Sub s2(x1, x2)
Call s1(x1, x1 + "(" + x2 + ")")
 
'名词复数
End Sub
===============
WORD VBA 打开一个电子表格,然后取其中的字段,并完成查找并替换
Sub Macro1()

Dim app As New Excel.Application
Dim wb As Excel.Workbook
Set wb = app.Workbooks.Open("c:\3gEnglish.xls")

 Selection.Find.ClearFormatting
 
    Selection.Find.Replacement.ClearFormatting
   
    x1 = wb.Sheets("sheet1").Range("a1")
    x2 = wb.Sheets("sheet1").Range("b1")
 
    Call s2(x1, x2)
 
app.Quit

   
End Sub
Sub s1(x1, x2)
       With Selection.Find
        .Text = x1
        .Replacement.Text = x2
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchByte = True
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
  Selection.Find.Execute Replace:=wdReplaceAll
  '查找并替换
End Sub

Sub s2(x1, x2)
Call s1(x1, x1 + "(" + x2 + ") ")
 
'名词复数
End Sub




0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有