VB中字符串数组快速复制的一种方法

最新推荐文章于 2023-01-26 22:18:39 发布

z-pan

最新推荐文章于 2023-01-26 22:18:39 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/rainstormmaster/archive/2006/01/02/309863.html

本文介绍了一种使用VBA实现字符串数组复制的方法，通过调用内核API函数CopyMemory来高效地完成复制任务。这种方法避免了循环遍历每个元素进行复制的繁琐过程，大大提高了代码效率。

Option Explicit
Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (dest As Any, source As Any, ByVal numBytes As Long)
Private Declare Sub ZeroMemory Lib "kernel32" Alias "RtlZeroMemory" (dest As Any, ByVal numBytes As Long)

Private Sub CopyStringArray(source() As String, dest() As String)
    Dim mLbound As Long, mUbound As Long, numBytes As Long
    mLbound = LBound(source)
    mUbound = UBound(source)
    numBytes = (mUbound - mLbound + 1) * 4
    ReDim dest(mLbound To mUbound) As String
    CopyMemory ByVal VarPtr(dest(mLbound)), ByVal VarPtr(source(mLbound)), numBytes
End Sub

转载于:https://www.cnblogs.com/rainstormmaster/archive/2006/01/02/309863.html