Muaj tseeb, thaum ua haujlwm hauv Microsoft Office program, koj xav ua kom yooj yim ua dua qhov qub. Piv txwv li, hloov cov lus txhais keyboard nkag, hom ntawv sau, lossis hloov cov ntaub ntawv hauv Excel lub rooj. Xav tias qhov kev ua no tuaj yeem txo qis mus nias ib tus yuam sij. Ntau npaum li cas nws yuav yooj yim rau kev ua haujlwm. Tab sis qhov no yog tiag tiag thiab ua tiav siv macros, uas yog txheej txheej.
Tsim nyog
- - Qhov kev pab cuam Microsoft Office;
- - siv Is Taws Nem.
Cov Lus Qhia
Kauj ruam 1
Koj tuaj yeem rub tawm ntau pob ntawm macros los ntawm Is Taws Nem. Raws li txoj cai, qhov no yog tag nrho pawg rau cov pab pawg uas xav tau tshaj plaws. Nws tseem yuav tsum tau coj mus rau hauv tus lej version ntawm Microsoft Office, vim macros uas tau tsim, piv txwv li, rau Microsoft Office 2003, kuj yuav tsis ua haujlwm rau Microsoft Office 2007.
Kauj ruam 2
Tab sis koj tsis tas yuav rub tawm txhua hom macros. Nws yog qhov txaus kom pom qhov macro koj xav tau hauv Is Taws Nem thiab download tau nws xwb. Piv txwv li, yog tias koj feem ntau yuav tsum tau sau cov ntawv, koj tuaj yeem rub tawm txheej txheej ntawm kev sau cov ntawv sau, tab sis yog tias koj feem ntau yuav tsum luam, ib qho macro rau kev luam cov ntaub ntawv.
Kauj ruam 3
Pib lub Microsoft Office tivthaiv. Tom qab ntawd xaiv "Cov Cuab Yeej", tom qab ntawd - "Macro" thiab "Visual Basic Editor". Ib lub khoos phis tawm ntawv yuav qhib. Nyob rau sab laug kawg kaum yog tshooj Seem Tshab. Hauv seem no, right-click rau ntawm kab Normal. Cov ntaub ntawv qhia ua zaub mov yuav tshwm sim, hauv qhov xaiv "Ntshuam Ntaub Ntawv".
Kauj ruam 4
Koj yuav pom ib lub qhov rai tuaj. Nyem rau ntawm "Cov ntaub ntawv ntawm yam" xub nyob rau hauv qab ntawm lub khawm tuaj. Tom qab ntawd xaiv VB Cov Ntaub Ntawv los ntawm daim ntawv teev npe, tom qab ntawd qhia meej txoj hauv kev mus rau nplaub tshev uas qhov macro koj xav tau nyob. Xaiv nws nrog cov nyem laug. Tom qab ntawd, hauv lub qhov rais xauj, nyem "Qhib". Kaw cov editor qhov rai thiab tshawb xyuas cov haujlwm ntawm macro koj tau ntxig.
Kauj ruam 5
Kuj tseem muaj kev qhia tshwj xeeb rau macros, uas suav nrog kev teeb tsa ntawm kev ua haujlwm rau ntau tus yeeb yam. Hauv qhov xwm txheej no, macros tsis tas yuav ntxiv los siv tus sau ntawv. Nyem rau ntawm phau ntawv nrog tus nas khawm xis, tom qab ntawd xaiv "Tsim" hauv cov ntawv qhia zaub mov. Lub macros yuav muab ntxiv.
