Excel通过OPC与AB实现读写.docVIP

1，ExcelOPCReadBlockTmStmp，EXCEL通过opc服务器读取数据，以及采集时间 ?Excel?VBA?Example?Code:?Read?multiple?data?elements?and?display?Timestamp?using?OPC Dim?OPCServer1?As?OPCServer?????????????Dimension?OPC?Server?andDim?WithEvents?OPCGroup1?As?OPCGroup????Group?objects Private?Sub?cmdDisconnect_Click()???????Terminate?OPC?Group?communications????On?Error?Resume?Next????????????????and?connection?to?OPC?Server????Set?OPCGroup1?=?Nothing?????????????????OPCServer1.Disconnect???????????????-?Ignore?errors?if?OPC?Server?or????Set?OPCServer1?=?Nothing??????????????Group?does?not?existEnd?Sub???????????????