使用正则表达式提取指定符号之间的所有子字符串

Excel 2007版

Private Function get_all_matches(phrase)
    Dim regEx As Object
    Dim result As Variant

    Set regEx = CreateObject("vbscript.regexp")

    With regEx
        .IgnoreCase = True
        .Pattern = "/.*/"
        .Global = True
    End With

    Set result = regEx.Execute(phrase)
    Set get_all_matches = result
End Function

然后我使用函数:

phrase = "where is /my/ ups /hiding/"
Set keys = get_all_matches(phrase)

结果是键(0)。值:“/my/ups/hidden/”。

换句话说,外部斜线之间的所有内容都被提取出来。 但预期的结果是:

keys(0).Value: "/my/"
keys(1).Value: "/hiding/"

你能帮我吗?