Excel VBA 读取保存Keysight示波器数据 平均模式

示波器型号：Keysight MSO-X 4154A

Excel版本：Microsoft Office Professional Plus 2010

引用：

VISA-COM 5.9 Type Library

Keysight VISA COM Resource Manager

平均模式时防止操作未完成发生错误：

->使能ESE中OPC，bit 0，&H01

->使用Digitized采集：写入":DIGitize"，写入"*OPC"

->有采集请求时ESR使STB bit6位置1

-> 检查STB中bit6位（&H20），置1开始读取数据

 

    Public myScope As New VisaComLib.FormattedIO488
    Public ioMgr As New VisaComLib.ResourceManager
    
    Public intFormat As Integer
    Public intType As Integer
    Public lngPoints As Long
    Public lngCount As Long
    Public Xincrement As Double
    Public Xorigin As Double
    Public Xreference As Long
    Public Yincre