当前位置:  开发笔记 > 编程语言 > 正文

vba二进制文件导致溢出

如何解决《vba二进制文件导致溢出》经验,为你挑选了1个好方法。

我正在尝试使用word中的宏将此数据写入二进制文件.如果我运行这个我得到这个错误"执行错误溢出(错误6)"就行了 #handle,CByte("&H"和输出(i))

我怎样才能解决这个问题?谢谢.

Sub HexStringToBinaryFile()


    lol50

    Dim output() As String
    output = Split(lol, "|")

    Dim handle As Long
    handle = FreeFile
    Open "C:\test.bin2" For Binary As #handle

    Dim i As Long
    For i = LBound(output) To UBound(output)

        Put #handle, , CByte("&H" & output(i))

    Next i

    Close #handle

End Sub
  Sub lol50()
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|01"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|02"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|03"


End Sub

Jason Faulkn.. 5

问题是你没有在lol分配行的末尾添加分隔符.因此,当它们被分割时,前一行的最后2位数与下一行的前2行连接.

这里发生错误:

lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|01"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"

解析它时,0100(在下一行)之间没有分隔符,因此0100产生溢出的值.

lol用a 结束每个赋值行,|错误应该消失.



1> Jason Faulkn..:

问题是你没有在lol分配行的末尾添加分隔符.因此,当它们被分割时,前一行的最后2位数与下一行的前2行连接.

这里发生错误:

lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|01"
lol = lol & "00|00|00|00|00|00|00|00|40|00|00|00|00|00|00|00"

解析它时,0100(在下一行)之间没有分隔符,因此0100产生溢出的值.

lol用a 结束每个赋值行,|错误应该消失.

推荐阅读
惬听风吟jyy_802
这个屌丝很懒,什么也没留下!
DevBox开发工具箱 | 专业的在线开发工具网站    京公网安备 11010802040832号  |  京ICP备19059560号-6
Copyright © 1998 - 2020 DevBox.CN. All Rights Reserved devBox.cn 开发工具箱 版权所有