条形码控件 void CBarCodeCtrl::SetBackColor(unsigned long newValue) { static BYTE parms[] = VTS_I4; InvokeHelper(DISPID_BACKCOLOR, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue); } unsigned long CBarCodeCtrl::GetBackColor() { unsigned long result; InvokeHelper(DISPID_BACKCOLOR, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL); return result; } void CBarCodeCtrl::SetForeColor(unsigned long newValue) { static BYTE parms[] = VTS_I4; InvokeHelper(DISPID_FORECOLOR, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue); } unsigned long CBarCodeCtrl::GetForeColor() { unsigned long result; InvokeHelper(DISPID_FORECOLOR, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL); return result; } short CBarCodeCtrl::GetStyle() { short result; InvokeHelper(0x1, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, NULL); return result; } void CBarCodeCtrl::SetStyle(short nNewValue) { static BYTE parms[] = VTS_I2; InvokeHelper(0x1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, nNewValue); } short CBarCodeCtrl::GetSubStyle() { short result; InvokeHelper(0x2, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, NULL); return result; } void CBarCodeCtrl::SetSubStyle(short nNewValue) { static BYTE parms[] = VTS_I2; InvokeHelper(0x2, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, nNewValue); } short CBarCodeCtrl::GetValidation() { short result; InvokeHelper(0x3, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, NULL); return result; } void CBarCodeCtrl::SetValidation(short nNewValue) { static BYTE parms[] = VTS_I2; InvokeHelper(0x3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, nNewValue); } short CBarCodeCtrl::GetLineWeight() { short result; InvokeHelper(0x4, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, NULL); return result; } void CBarCodeCtrl::SetLineWeight(short nNewValue) { static BYTE parms[] = VTS_I2; InvokeHelper(0x4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, nNewValue); }

Me.BarCodeCtrl1.Style = 7 Me.BarCodeCtrl1.Value = "56546546456" 使用非常方便

excel条码制作必须文件。

microsoft BarCode control

MSBCODE9.OCX 条形码 微软条形码预控件 MSBCODE9.OCX 微软条形码控件MSBCODE9.OCX 内附有条形码制作方法。

Microsoft Barcode控件详解： https://blog.csdn.net/weixin_37914760/article/details/111403116

MSBCODE9.OCX是微软条形码控件用到的一个对象扩充组件，一般来说在进行条形码打印的时候会用到这个组件，经用户测试可以完美兼容office2007以及以及以上的版本，下载注册之后就可以正常使用了，有需要的办公用户快快下载吧。