Kwa ambiri ogwiritsira ntchito Mawu, mawu akuti "macro" amachititsa mantha m'mitima yawo, makamaka chifukwa samamvetsetsa macros Mawu ndipo mwachiwonekere sanadzipange okha. Mwachidule, lalikulu ndi malamulo angapo omwe amalembedwa kotero akhoza kusewera mmbuyo, kapena kuphedwa, kenako. Mwamwayi, kupanga ndi kuyendetsa macros sikovuta, ndipo zotsatira zake zimakhala bwino kupatula nthawi yophunzira kuzigwiritsa ntchito. Pitirizani kuwerenga kuti mudziwe momwe mungagwirire ntchito ndi Macros mu Mawu 2003 . Kapena, phunzirani kulemba macros mu Mawu 2007 . Pali njira zingapo zopangira mau macros: Njira yoyamba, ndi yosavuta, ndiyo kugwiritsa ntchito zojambula zazikulu; Njira yachiwiri ndiyo kugwiritsa ntchito VBA, kapena Visual Basic kwa Ma Applications. Komanso, macros Mawu akhoza kusinthidwa pogwiritsa ntchito VBE, kapena Visual Basic Editor. Visual Basic ndi Visual Basic Editor zidzakambidwa muzophunzitsira zotsatirazi. |
- Pa Zida zamkati, dinani Macro.
- Dinani Macros ... kuchokera ku submenu; Mukhozanso kugwiritsa ntchito fungulo lachidule la Alt + F8 kuti mupeze Macros dialog box.
- Menyu yotsitsa pambali pa "Macros mu" lemba, sankhani Malamulo a Mawu .
- Mndandanda wa malemba a ma alfabheti a maina a command adzawoneka. Ngati mukulongosola dzina, kufotokoza kwa lamulo kudzaonekera pansi pa bokosi, pansi pa lemba la "Description".
Ngati lamulo limene mukufuna kulenga liripo kale, simuyenera kulenga lanu Mau macro. Ngati kulibe, muyenera kupita ku tsamba lotsatira lomwe likuphatikiza kupanga ndondomeko yanu ya Mawu.
Mmene Mungapangire Mau Macros Ogwira Ntchito
Chinthu chofunikira kwambiri pakupanga macros Mawu abwino ndi kukonzekera mosamala. Ngakhale zikhoza kuwonekera momveka bwino, muyenera kukhala ndi lingaliro lomveka la zomwe mukufuna Mawu a macro achite, momwe zidzathandizira kuti tsogolo lanu likhale losavuta komanso momwe mukufunira kuzigwiritsa ntchito.
Apo ayi, mungathe kumaliza nthawi yopanga zinthu zopanda ntchito zomwe simungagwiritse ntchito.
Mukakhala ndi zinthu izi m'maganizo, ndi nthawi yokonzekera masitepe enieni. Izi ndizofunikira chifukwa chojambula adzakumbukira kwenikweni zomwe mukuchita ndikuziphatikizira muzinthu zambiri. Mwachitsanzo, ngati mwalemba chinachake ndikuchichotsa, nthawi iliyonse imene muthamanga Mawu ambiri amapanga zofanana ndikuzichotsa.
Mutha kuona momwe izi zingapangidwire kuti zikhale zopanda pake komanso zopanda ntchito.
Pamene mukukonzekera macros anu, pano pali zinthu zofunika kuziganizira:
- Konzani malamulo ndi dongosolo limene mukufuna kuti macro achite.
- Dziwani makiyi afupikitsidwe a malamulo omwe mukufuna kuti mugwiritse ntchito. Izi ndizofunikira kwambiri pazomwe mukuyenda; simungagwiritse ntchito mbewa kuti muziyenda mkati mwa chigawocho pamene mukuyimba nyimbo. Kuwonjezera pamenepo, mudzakhazikitsa machulukiti ngati mutagwiritsa ntchito makiyi afupikitsidwe m'malo mwa makiyi, kuti aliyense akuphatikizidwe.
- Sungani mauthenga omwe Mawu angasonyeze ndipo amaletsa macro.
- Gwiritsani ntchito masitepe ochepa kuti muzitsamira kwambiri.
- Pezani mayesero amodzi musanayambe kujambula.
Mukakonzekera Mawu anu macro ndikuthawa, muli okonzeka kuwina.
Ngati mwakonzeratu zochuluka zanu, kuzilemba kuti zitha kugwiritsidwa ntchito m'tsogolomu zidzakhala zovuta kwambiri. Ndichophweka, makamaka, kuti kusiyana kokha pakati pa kupanga macro ndi kugwira ntchito pazomwekulembedwa ndikuti muyenera kusindikiza mabatani angapo owonjezera ndikupanga mndandanda wambiri muzokambirana.
Kukhazikitsa Zojambula Zanu za Macro
Choyamba, dinani Zida m'ndandanda ndikusindikizani Record New Macro ... kuti mutsegule Bokosi la Mauthenga.
M'bokosi pansi pa "dzina la macro," lembani dzina lapadera. Mayina akhoza kukhala ndi makalata oposa 80 kapena manambala (palibe zizindikiro kapena malo) ndipo ayenera kuyamba ndi kalata. Ndikoyenera kuti afotokoze zochitika zomwe macro amachita mufotokozera bokosi. Dzina limene mumapatsa macro liyenera kukhala lopadera kwambiri kuti mumakumbukire zomwe limapanga popanda kunena zafotokozedwa.
Mutangotchula dzina lanu ndipo munalowa ndondomeko, sankhani ngati mukufuna kuti maofesi onse akhalepo m'malemba onse kapena pakalata. Mwachizolowezi, Mawu amapangitsa malemba onse kupezeka pamapepala anu onse, ndipo mwinamwake mudzapeza kuti izi zimakhala zomveka kwambiri.
Ngati mutasankha kuchepetsa kupezeka kwa lamulo, komabe, tangoganizirani dzina lachikwama mubokosi lotseketsa pansipa "Sungani Macro mu" lemba.
Mukalowa muzolemba zazikulu, dinani OK . The Record Macro Toolbar idzawonekera pamakona a kumanzere a chinsalu.
Lembani Macro Yanu
Chojambula cha phokoso tsopano chikhala ndi chifanizo chaching'ono chomwe chikuwoneka ngati tepi ya tepi pambali pake, kusonyeza kuti Mawu akulemba zochitika zanu. Mukutha tsopano kutsatira ndondomeko yomwe mwaiyika mu siteji yokonza; Mukamaliza, pewani batani la Stop (ndilo bwalo la buluu kumanzere).
Ngati, pa chifukwa chilichonse, muyenera kusiya kupuma, dinani Pause Recording / Resume Recorder batani (ndiyo ili kumanja). Kuti mupitirize kujambula, dinani kachiwiri.
Mukasindikiza batani, Mawu anu macro ndi okonzeka kugwiritsa ntchito.
Yesani Macro Wanu
Kuti muyambe kugwiritsa ntchito makina anu, gwiritsani ntchito fungulo lachidule la Alt + F8 kuti mubweretse bokosi la ma bokosi la Macros. Sungani zolemba zanu m'ndandanda ndipo dinani Kuthamanga . Ngati simukuwona zovuta zanu, onetsetsani kuti malo abwino ali m'bokosi pambali pa "Macros".
Cholinga cha kulenga macros mu Mawu ndi kufulumizitsa ntchito yanu mwa kuika ntchito zobwerezabwereza ndi kutsatira zovuta za malamulo pamtundu wanu. Chimene chingatenge maola enieni kuti chichite mwangozi chimangotenga masekondi angapo pang'onopang'ono pa batani.
Inde, ngati mudapanga macros ambiri, kufufuza mu bokosi la ma bokosi la Macros kudzadya nthawi yambiri imene mumasunga. Ngati muika makros anu makiyi afupikitsi, komabe mungathe kudutsa bokosi la bokosi ndi kupeza majekiti anu molunjika kuchokera ku khibhodi-njira yomweyo yomwe mungagwiritsire ntchito makina ochezera kuti mupeze malamulo ena mu Mawu.
Kupanga Mafupomu Achifungulo a Makedoni a Macros
- Kuchokera Zida zamakono, sankhani Pezani ...
- Mu bokosi la dialog Customize, dinani Keyboard .
- Bokosi lachikhodi la bokosi la bokosi lidzatsegulidwa.
- Mu bokosi la mpukutu pansi pa "Makina" chizindikiro, sankhani Macros.
- Mu bokosi la mabukhu la Macros, pezani dzina la macro omwe mungakonde kugawa makina oyendetsa.
- Ngati pulogalamuyi ili ndi tsamba loyamba, tsamba loyamba lidzawoneka m'bokosi ili m'munsimu la "Mafelemu a Tsopano".
- Ngati palibe makina osatsegulira apatsidwa ku macro, kapena ngati mukufuna kupanga chifungulo chachiwiri chachidule cha wanu, dinani mu bokosi ili m'munsimu chizindikiro "Yesetsani makina atsopano."
- Lowani zovuta zomwe mungafune kugwiritsa ntchito kuti mupeze zambiri. (Ngati makiyi afupikitsidwe aperekedwa kale ku lamulo, uthenga udzawoneka pansi pa bokosi la "Mawandilo Otsopano" omwe akuti "Pakali pano wapatsidwa" potsatira dzina la lamulo. Mungathe kubwezeretsanso chingwechi mwa kupitilira, kapena mungathe kusankha chikhomo chatsopano).
- Mu bokosi lochotsa pansi pambali pamatchulidwe akuti "Sungani kusintha" sankhani Zomveka kuti mugwiritse ntchito kusintha kwa malemba onse opangidwa m'Mawu. Kuti mugwiritse ntchito fungulo lachindunji pokhapokha pacholembedwacho, sankhani dzina lachilembacho kuchokera pandandanda.
- Dinani Kugawa .
- Dinani Kutseka .
- Dinani Kutsekula pa bokosi la zokambirana la Customize.