Recent content by hswerdfe

  1. H

    return rows in Query from variant array return from VBA UDF

    current function, is very basic. Public Function Words(ByVal orig As String) As Variant Dim regEx As New VBScript_RegExp_55.RegExp regEx.Pattern = "\b\w+\b" regEx.Global = True If regEx.test(orig) Then Set Words = regEx.Execute(orig) Else Set Words = Nothing...
  2. H

    return rows in Query from variant array return from VBA UDF

    I have a simple UDF that takes a string and returns a variant, which is an array of strings Example Input "Brick Wall" Return value would be a variant array with first element "Brick" and and second element "Wall" Now I have a table with a field of strings, and I want to make a query that...
Back
Top Bottom