Cov ntawv qhia no piav qhia yuav tsim kev sib txuas lus ntawm lub sijhawm tiag tiag li cas ntawm Microsoft Excel thiab koj li RS232 COM Port cov khoom siv xws li Nplai, Kev Nyeem Ib Ntus, Barcode nyeem ntawv, ntsuas kub, Caliper, Micrometer, Gage. Qhov kev daws teeb meem no siv software "Bill Redirect" nrog "Excel Plugin" kom yooj yim txuas koj cov khoom siv sab nraud thiab tau txais thiab xa cov ntaub ntawv. Kev sib txuas lus ntawm Microsoft Excel thiab koj lub cuab yeej yog ua los ntawm DDE txuas ncaj qha. Excel Macro tuaj yeem raug hu tom qab txhua cov ntaub ntawv tau txais los ntawm koj lub cuab yeej los txheeb xyuas cov ntaub ntawv tau txais. Cov tshuaj no piav qhia yuav ua li cas koj tuaj yeem xa cov lus txib ntawm VBA rau koj lub cuab yeej thiab tswj koj lub cuab yeej. Tsis xav tau lub cajmeem lossis kho vajtse ntxiv!
Cov kauj ruam
Ntu 1 ntawm 6: Txhim Kho Software (Tsim RS232 & DDE Kev Sib Txuas Lus)
Kauj Ruam 1. Rub tawm thiab teeb tsa Bill Redirect software:
www.billproduction.com/Bill_COMtoKB. ZIP. Qhov software no yog siv los tsim kev sib txuas lus nrog koj li RS-232 COM Port device.
Kauj Ruam 2. Rub tawm thiab teeb tsa Excel plugin
Nov yog ntawm https://www.billproduction.com plugin_DDE.zip. Qhov software no siv los tsim kev sib txuas lus nrog Microsoft Excel ntawm DDE
Ntu 2 ntawm 6: Bill Rov Xa Rov Qab Software (General Configuration)
Kauj Ruam 1. Pib lub software: Bill Redirect. Tus password tsis raug los kho qhov teeb tsa yog: www.billproduction.com.
Kauj Ruam 2. Ua tsis tau txhua ntu tshwj tsis yog Serial Port and Plugin
- Hauv ntu "Serial Port" teeb tsa hloov mus rau: Nyob.
- Hauv ntu "Plugin" teeb tsa hloov mus rau: Nyob.
Ntu 3 ntawm 6: Bill Redirect Software (RS232 Serial Port configuration)
Kauj ruam 1. Nyem rau: Serial Port Configuration.
Kauj Ruam 2. Sau Tus Naj Npawb Serial uas koj lub cuab yeej txuas nrog
-
Yog tias keeb kwm yav dhau xim ntsuab, nws txhais tau tias qhov chaw nres nkoj txuas ua haujlwm thiab chaw nres nkoj tau qhib.
Xaiv lub Bauds, Parity thiab Databits teeb tsa hauv koj lub cuab yeej.
Kauj ruam 3. Nyem rau khawm: Txuag Configuration
Yog tias koj siv RS-232 rau USB hloov pauv kom txuas koj lub cuab yeej ntawm lub khoos phis tawj, nws yog qhov tseem ceeb kom siv lub hloov pauv nrog FTDI chipset rau kev ruaj ntseg zoo
Ntu 4 ntawm 6: Microsoft Excel (Kev teeb tsa dav dav)
Kauj Ruam 1. Pib:
Microsoft Excel
. Cov tshuaj no yog sib xws nrog txhua Excel version thiab lus!
Kauj Ruam 2. Tsim ib qho hauv Excel a: daim ntawv tshiab uas tsis muaj dab tsi.
Kauj Ruam 3. Nco ntsoov tias daim ntawv npe yog: Sheet1.
Kauj Ruam 4. Txuag koj daim ntawv Excel rau: C: / BillProduction. CFG / MyFile.xlsx.
Ntu 5 ntawm 6: Excel Plugin Configuration
Kauj Ruam 1. Pib Excel Plugin
Tus password tsis raug los kho qhov teeb tsa yog: www.billproduction.com.
- Tseem ceeb: Qhov xwm txheej sib txuas TCP yuav tsum qhia: Txuas. Yog nws tsis yog Txuas tom qab ntawd nco ntsoov tias Bill Redirect Software tau qhib.
- Hauv kev sim koj yuav tsum rov pib dua software Bill Redirect tom qab txhua 15 feeb los txuas ntxiv koj qhov kev sim."
Kauj Ruam 2. Hauv Excel Plugin nyem rau ntawm daim nplaub tshev icon thiab xaiv koj li Excel Cov Ntaub Ntawv tsim los ntawm kauj ruam ua ntej
- Yog tias txhua yam ua tau zoo, DDE Kev Sib Txuas Raws Cai qhia: Txuas.
- Txij ntawm no mus kev sib txuas lus tau tsim nrog koj li cuab yeej ntawm Excel. Cov ntaub ntawv tau txais los ntawm koj lub cuab yeej raug xa hauv Excel.
Kauj Ruam 3. Ntsuas koj kev sib txuas lus nrog Excel
Siv lub pob: Ntsuas DDE. Txhawm rau pom dab tsi koj lub cuab yeej xa lossis tau txais, siv ntu Debugger hauv Bill Redirect.
Ntu 6 ntawm 6: Muaj Ntau Txoj Kev Xaiv
Kauj Ruam 1. Xav txog qhov piv txwv #1: 'Hu rau Excel Macro tom qab txhua cov ntaub ntawv tau txais:
- Cias sau koj lub npe macro hauv daim teb Khiav macro:
- Txhawm rau sim hu ntawm koj lub macro siv lub pob ntawm sab xis.
Kauj Ruam 2. Xav txog qhov piv txwv #2: 'Xa cov lus txib rau koj lub cuab yeej ntawm VBA:
Kauj Ruam 3. Txhawm rau xa cov ntaub ntawv txib los ntawm Excel rau koj lub cuab yeej siv VBA Excel qhov chaws no:
- ChannelNumber = DDEInitiate ("BPEXCEL", "BPEXCEL")
- DDEExecute ChannelNumber, "{TX_SERIAL [Nyob Zoo Lo Lus! {ASCII: 13}]}"
- DDETerminate ChannelNumber
- Hloov cov lus txib Nyob Zoo Lo Lus! {ASCII: 13} los ntawm cov lus txib koj xav tau.
- Cov ntaub ntawv ntxiv.
- Excel Plugin tag nrho phau ntawv qhia nrog txhua qhov kev piav qhia:
- /Bill_DDE_over_Ethernet.pdf.
-
Bill Redirect Software tag nrho phau ntawv qhia nrog txhua qhov hais kom ua:
www.billproduction.com
- /Bill_Redirect_Manual.pdf.