C
Captain Nemo
Gang -
Microsoft provides this website
http://support.microsoft.com/default.aspx?scid=kb;en-us;188007
on how to move these VBA functions into VBA5:
Function Description
-------- -----------
Join Used to join arrays elements.
Split Split a string into a variant array.
InStrRev Similar to InStr but searches from end of string.
Replace To find a particular string and replace it.
Reverse To reverse a string.
The Split Function, quoted below gives a
Compile error: Automaton type not supported in Visual Basic
Public Function Split(ByVal sIn As String, Optional sDelim As _
String, Optional nLimit As Long = -1, Optional bCompare As _
VbCompareMethod = vbBinaryCompare) As Variant
Dim sRead As String, sOut() As String, nC As Integer
If sDelim = "" Then
Split = sIn
End If
sRead = ReadUntil(sIn, sDelim, bCompare)
Do
ReDim Preserve sOut(nC)
sOut(nC) = sRead
nC = nC + 1
If nLimit <> -1 And nC >= nLimit Then Exit Do
sRead = ReadUntil(sIn, sDelim)
Loop While sRead <> ""
ReDim Preserve sOut(nC)
sOut(nC) = sIn
Split = sOut
End Function
What's up with the error, and what can I do?
....Best, Captain Nemo
Microsoft provides this website
http://support.microsoft.com/default.aspx?scid=kb;en-us;188007
on how to move these VBA functions into VBA5:
Function Description
-------- -----------
Join Used to join arrays elements.
Split Split a string into a variant array.
InStrRev Similar to InStr but searches from end of string.
Replace To find a particular string and replace it.
Reverse To reverse a string.
The Split Function, quoted below gives a
Compile error: Automaton type not supported in Visual Basic
Public Function Split(ByVal sIn As String, Optional sDelim As _
String, Optional nLimit As Long = -1, Optional bCompare As _
VbCompareMethod = vbBinaryCompare) As Variant
Dim sRead As String, sOut() As String, nC As Integer
If sDelim = "" Then
Split = sIn
End If
sRead = ReadUntil(sIn, sDelim, bCompare)
Do
ReDim Preserve sOut(nC)
sOut(nC) = sRead
nC = nC + 1
If nLimit <> -1 And nC >= nLimit Then Exit Do
sRead = ReadUntil(sIn, sDelim)
Loop While sRead <> ""
ReDim Preserve sOut(nC)
sOut(nC) = sIn
Split = sOut
End Function
What's up with the error, and what can I do?
....Best, Captain Nemo