要处理word对象时,首先请在VB菜单中选择Project->References,然后选中Microsoft Word Object Libaray,然后:
您可以参考以下代码实现您要实现的功能
‘声明对象
Dim oApp As Word.Application
Dim oDoc As Word.Document
Dim Content As String ‘保存内容的字符串
‘打开需要的文件
Set oApp = CreateObject("Word.Application")
oApp.Visible = false
Set oDoc = oApp.Documents.Open("C:\Text.doc")
Content = oDoc.Content.Text
‘获得最后一段的内容
Dim length As Long ‘整个文档的长度
Dim i As Long
length = oDoc.Content.StoryLength
Content = oDoc.Content.Text
For i = length - 1 To 1 Step -1
If Mid$(Content, i, 1) = Chr$(13) Then
Exit For
End If
Next i
Content = Mid$(Content, i) ‘此时为最后一段的内容
‘增加一段内容
oDoc.Content.Text=oDoc.Content.text & “I Add a paragraph”
Dim xlApp As Excel.Application
Dim excelWorkBook As Excel.Workbook
Dim excelWorkSheet As Excel.Worksheet
Set excelWorkBook = xlApp.Workbooks.Add()
excelWorkBook.Sheets("记录簿").Select
(或者这样:excelWorkBook.Sheets(1).Select)
Set excelWorkSheet = excelWorkBook.Sheets("记录簿")