从字符串中提取引号中的单词

您不需要正则表达式来执行此操作，请尝试：

Sub Test()
    Dim s As String
    s = "(I open my eyes and said ""hello to the ""world"")"
    Debug.Print s
    s = Mid(Left(s, InStrRev(s, """")), InStr(s, """"))
    Debug.Print s
End Sub

此打印

(I open my eyes and said "hello to the "world")
"hello to the "world"

我想将其写为正则表达式的简单方法是：

""".+"""

有关如何在 VBA 中使用正则表达式的参考：
如何在 Microsoft Excel 中使用正则表达式 （Regex） 单元内和循环

使用此示例代码进行测试

Sub RegexMatchingAndDisplayingAPattern()
Dim stringOne As String
Dim regexOne As Object
Dim theMatches As Object
Dim Match As Object
Set regexOne = New RegExp

regexOne.Pattern = """.+"""
stringOne = "(I open _my eyes_ and said  ""hello to the ""world"")"

Set theMatches = regexOne.Execute(stringOne)

For Each Match In theMatches
  Debug.Print Match.Value
Next

End Sub