Microsoft's Visual Basic for Applications (VBA) yog tus qauv lus rau kev sau cov haujlwm kom siv lub luag haujlwm thiab haujlwm hauv Microsoft Office. Nkag siab yuav ua li cas tiv thaiv VBA cov cai yog li lwm tus tsis tuaj yeem ua phem lossis nyiag koj lub macros.
Txog kev tiv thaiv thiab tshem tawm VBA tus lej zais, saib tsab xov xwm no.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Ruaj Ntseg VBA Code nrog Tus Kheej
Kauj Ruam 1. Qhib Visual Basic Editor, feem ntau pom nyob hauv "Macro" hauv "Tools" menu
(Hauv Kev Nkag Mus, koj yuav xav tau nyob hauv lub qhov rai database kom mus txog tus kws kho mob, nyob ntawm koj lub computer teeb tsa.)
-
Xaiv "Project Properties" hauv "Tool" menu hauv Visual Basic Editor.
Tiv thaiv VBA Code Kauj Ruam 1 Bullet 1
Kauj Ruam 2. Mus rau "Kev Tiv Thaiv" tab
Kauj Ruam 3. Xaiv lub thawv "Xauv Project rau Saib"
Yog tias koj tsis khij lub npov no, koj yuav tsis zais koj tus lej.
Kauj Ruam 4. Tsim thiab lees paub koj tus password uas xav tau hauv cov thawv qhia
Kauj Ruam 5. Txuag, kaw, thiab rov qhib koj phau ntawv rau kev tiv thaiv kom siv tau
(Hauv Microsoft Excel 2007 thiab tom qab, koj yuav xav khaws ua XLSM cov ntaub ntawv rau koj cov cai ua haujlwm.)
Txoj Kev 2 ntawm 3: Nkaum VBA Code hauv Nyeem-Tsuas File nrog Access 2007
Kauj Ruam 1. Mus rau "Database Tools" tab
Kauj Ruam 2. Nrhiav pawg "Database Tools"
Kauj Ruam 3. Xaiv "Ua ACCDE
Kauj Ruam 4. Txuag ACCDE cov ntaub ntawv nrog lub npe cais los ntawm cov ntawv qub
Cov ntaub ntawv ACCDE yog hom ntawv nyeem nkaus xwb, yog li koj yuav tsum khaws cov ntawv qub, ib yam, kom muaj peev xwm hloov pauv tau.
Txoj Kev 3 ntawm 3: Tiv Thaiv Koj Li VBA Code los ntawm Kev Ua Ntxiv
Kauj Ruam 1. Tsim cov ntaub ntawv chaw ua haujlwm tsis muaj dab tsi ntawm hom uas yuav siv koj cov cai
(Piv txwv li, yog tias koj tus lej ua haujlwm nrog MS Excel, tsim cov ntawv Excel.)
Kauj Ruam 2. Luam koj tus lej VBA rau hauv Visual Basic Editor ntawm cov ntawv ntawd
Kauj Ruam 3. Qhib lub qhov rai "Macros", feem ntau khaws cia hauv "Cov Cuab Yeej"
Kauj Ruam 4. Kuaj koj cov cai dua, uas debug nws
Kauj Ruam 5. Tshem tawm ib yam dab tsi ntxiv rau hauv cov ntawv uas tsis yog los ntawm koj qhov kev xeem
Kauj Ruam 6. Ntxiv cov lus piav qhia rau lub macro uas yuav khiav hauv koj qhov ntxiv
(Koj yuav xav xaiv macro "Options" kom muaj peev xwm ntxig cov lus piav qhia.)
Kauj Ruam 7. Sau koj cov cai
(Hauv Visual Basic Editor, saib hauv qab "Debug" ntawv qhia zaub mov thiab xaiv "Compile VBA Project.")
Kauj Ruam 8. Txuag daim ntawv theej ntawm cov ntawv ua hom ntawv
Kauj Ruam 9. Mus rau "Cuab Yeej" hauv Visual Basic Editor, tom qab ntawd xaiv "Project Properties
Kauj Ruam 10. Xaiv lub tab "Tiv Thaiv"
Kauj Ruam 11. Qhib lub thawv "Xauv Project rau Saib"
(Koj kuj tseem yuav xav teeb tus password, nyob ntawm seb hom ntaub ntawv tshwj xeeb uas koj tab tom ua haujlwm nrog thiab koj teeb tsa rau MS Office thiab koj lub khoos phis tawj.)
Kauj Ruam 12. Qhib "Save As " lossis "Save a Copy" dialog box
Kauj Ruam 13. Nkag mus rau cov ntawv qhia zaub mov nco-down thiab hloov cov ntaub ntawv mus rau hom tsim nyog ntawm kev ntxiv-hauv
- Txuag Microsoft Word ntxiv-ntxiv ua DOT cov ntaub ntawv, cov ntawv ua qauv. (Yog tias koj xav kom cov add-in khiav thaum koj pib Lo Lus, khaws nws hauv Lo Lus Lo Lus Pib.)
- Txuag Microsoft Excel ntxiv-ntxiv ua XLA cov ntaub ntawv.
- Txuag Microsoft Access ntxiv-ntxiv ua MDE cov ntaub ntawv, uas yuav tiv thaiv VBA tus lej. (Microsoft Access add-ins kuj tseem tuaj yeem khaws ua ntaub ntawv MDA, tab sis qhov no tsis zais qhov chaws.)
- Txuag Microsoft PowerPoint ntxiv-ntxiv ua PPA cov ntaub ntawv uas yuav zais VBA cov cai thiab tso nws tsis tuaj yeem ua rau lwm tus uas tsis yog koj li nkag mus rau lossis kho nws.
Kauj Ruam 14. Tawm thiab rov qhib Microsoft Office
Tam sim no koj cov ntawv ntxiv yuav tsum siv tau.
Lub tswv yim
- Yog tias koj tsis tuaj yeem pom VBA Editor lossis Tus Thawj Saib Xyuas Ntxiv, xyuas kom nws tau teeb tsa ntawm koj lub khoos phis tawj. Yog tias tsis yog, koj yuav xav tau nkag mus rau koj lub Office suite installation disks txhawm rau txhim kho cov haujlwm tsim nyog.
- Koj cov kev teeb tsa tshwj xeeb thiab teeb tsa rau Microsoft Office tuaj yeem cuam tshuam qhov chaw sib txawv nyob hauv txhua qhov haujlwm. Yog tias koj tsis tuaj yeem nrhiav lub luag haujlwm, sim khiav nrawm "Pab" tshawb rau lub npe ua haujlwm.
