Function JisToStr(ByVal Str As String, Nbr As Integer) As String
On Error Resume Next
Dim Stm As ADODB.Stream
Dim StrByt() As Byte
Dim n01 As Integer
Dim m01 As Integer
Dim Asr01Str As String
Set Stm = New ADODB.Stream
Asr01Str = ""
m01 = 0
For n01 = 1 To Nbr Step 2
If Mid(Str, n01, 1) = "#" Then
Asr01Str = Asr01Str & Mid(Str, n01 + 1, 1)
ElseIf Mid(Str, n01, 1) = "" Then
Exit For
Else
ReDim StrByt(7)
StrByt(0) = 27
StrByt(1) = 36
StrByt(2) = 66
StrByt(3) = Asc(Mid(Str, n01, 1))
StrByt(4) = Asc(Mid(Str, n01 + 1, 1))
StrByt(5) = 27
StrByt(6) = 40
StrByt(7) = 66
If Err.Number = 3705 Then
Stm.Close
End If
Stm.Open
Stm.Type = adTypeBinary
St
On Error Resume Next
Dim Stm As ADODB.Stream
Dim StrByt() As Byte
Dim n01 As Integer
Dim m01 As Integer
Dim Asr01Str As String
Set Stm = New ADODB.Stream
Asr01Str = ""
m01 = 0
For n01 = 1 To Nbr Step 2
If Mid(Str, n01, 1) = "#" Then
Asr01Str = Asr01Str & Mid(Str, n01 + 1, 1)
ElseIf Mid(Str, n01, 1) = "" Then
Exit For
Else
ReDim StrByt(7)
StrByt(0) = 27
StrByt(1) = 36
StrByt(2) = 66
StrByt(3) = Asc(Mid(Str, n01, 1))
StrByt(4) = Asc(Mid(Str, n01 + 1, 1))
StrByt(5) = 27
StrByt(6) = 40
StrByt(7) = 66
If Err.Number = 3705 Then
Stm.Close
End If
Stm.Open
Stm.Type = adTypeBinary
St