作为一个非程序员,以下是我对如何复制/粘贴每一段的第一句话的一些想法,非VBA:
模糊终结点作为字符串
我能用VBA做这个吗?我怎么开始呢?
发布于 2014-07-21 20:41:19
下面是从文档中的每个段落中提取第一个语句的示例。这将是在Word应用程序中编写并调用的代码。
Sub test()
Dim doc As Document
Dim p As Paragraph
Dim s As String
Set doc = ActiveDocument
For Each p In doc.Paragraphs
Debug.Print p.Range.Sentences(1)
Next
End Sub在Excel中,一个简单的例程,将第一句放在active Excel工作簿中的新工作表中:
Sub GetSentences()
'Word objects
Dim wdApp as Object
Dim doc as Object
Dim p as Object
Dim s as String
Dim ws as Worksheet
Set wdApp = CreateObject("Word.Application")
Set doc = wdApp.Documents.Open("c:\your filename.docx")
For each p in doc.Paragraphs
Set ws = Worksheets.Add
ws.Range("A1").Value = p.Range.Sentences(1)
Next
End Subhttps://stackoverflow.com/questions/24873990
复制相似问题