以前总是搜索,可是这个问题我遍搜不到,希望高手帮帮忙
vb调用word的时候,我实现的是替换功能,但是如果此时有文档已经打开,居然会替换到以前的文档中而我想要的文档纹丝不动……不知道我表述的清楚不,我想让他直接插入到我想要的文档中而不是其他的文档,怎么办。谢谢!
代码:Private Sub Command4_Click()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = True
Set wdDoc = wdApp.Documents.Open("E:\1.dot ")
wdDoc.SaveAs ("E:\111.doc") Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "pinming"
.Replacement.Text = "品名"
.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
wdDoc.Save
Set wdDoc = Nothing
Set wdApp = Nothing
End Sub
vb调用word的时候,我实现的是替换功能,但是如果此时有文档已经打开,居然会替换到以前的文档中而我想要的文档纹丝不动……不知道我表述的清楚不,我想让他直接插入到我想要的文档中而不是其他的文档,怎么办。谢谢!
代码:Private Sub Command4_Click()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = True
Set wdDoc = wdApp.Documents.Open("E:\1.dot ")
wdDoc.SaveAs ("E:\111.doc") Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "pinming"
.Replacement.Text = "品名"
.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
wdDoc.Save
Set wdDoc = Nothing
Set wdApp = Nothing
End Sub
解决方案 »
- 求有中断功能的函数,类似msgbox
- VB TreeView基础问题,请高手帮忙
- 请问怎样将VSFlexGrid数据导入EXCEL
- 如何判断picturebox控件载入的图片名字不同?
- 帮忙!!一个查询问题!!!
- the rowset is not bookmarkable这个错误提示是怎么回事
- 如何使用vs2010中的visualbasic功能
- 游戏中常用的“战况”,或“英雄榜”(比如说扫雷)英文怎么说啊?
- 如何用代码实现数据库的备份与恢复
- 如何做图片分割?
- 求助strsql = "select * from" & Combo2.Text & " where 日期 = #" & CDate(Combo3.Text)
- 请VB高手一个一维离散小波变换的程序
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = CreateObject("Word.Application")
三句修改为
Dim wdApp As New Word.Application
Dim wdDoc As New Word.Document
昨晚喝多酒了,回复失当,请谅解!