Search results
-
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...- hswerdfe
- Post #3
- Forum: Modules & VBA
-
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...- hswerdfe
- Thread
- Replies: 3
- Forum: Modules & VBA