Macro ndi gulu la zochita, malangizo, ndi / kapena malangizo omwe m'magulu awiri amodzi omwe amachita ntchito imodzi yokha. Ngati ndinu ogwiritsa ntchito a MS Mawu, muthanso kupanga magwiridwe antchito pafupipafupi mwa kuwapangira ma macro oyenerera.
Ziri momwe mungaphatikizire ma macros ku Mawu, momwe mungapangire ndikugwiritsa ntchito kuti muchepetse, kufulumira kwa mayendedwe ake ndipo tidzakambirana m'nkhaniyi. Ndipo, poyambira, sichikhala chopanda nzeru kumvetsetsa mwatsatanetsatane chifukwa chake akufunika nkomwe.
Kugwiritsa Ntchito Macro
- 1. Kuthamanga kwa ntchito zochitidwa pafupipafupi. Izi zikuphatikiza kusanja ndi kusintha.
Kuphatikiza magulu angapo muzochita zonse kuchokera “mpaka” Mwachitsanzo, pogwiritsa ntchito macro, mutha kuyika tebulo la saizi yopatsidwa ndi mizere ndi mizati yoyenera.
3. Kupepuka kwa magawo ndi zida zina zomwe zimakhala m'mabokosi osiyanasiyana amakono a pulogalamuyo.
4. Makina a zochita zovuta.
Ma macros angapo amatha kulembedwa kapena kupangika kuyambira pakukonza poyambitsa kachidindo mu Visual Basic mkonzi m'chinenerocho cha dzina lomweli.
Yambitsani Macros
Mwachisawawa, ma macro sapezeka mu mitundu yonse ya MS Mawu, moyenera, samangophatikizidwa. Kuti muwayambitse, muyenera kuloleza zida zopangira mapulogalamu. Pambuyo pake, tabu idzaonekera pagulu lolamulira la pulogalamuyo "Wopanga". Werengani momwe mungapangire izi pansipa.
Chidziwitso: M'mitundu yamapulogalamu omwe ma macros amapezeka koyambirira (mwachitsanzo, Mawu 2016), zida zogwiritsira ntchito nawo zilipo tabu "Onani" pagululi "Macros".
1. Tsegulani menyu "Fayilo" (Batani la "Microsoft Office" m'mbuyomu).
2. Sankhani “Zosankha” (kale anali “Mawu Osankha”).
3. Tsegulani pazenera “Zosankha” gulu "Zoyambira" ndikupita ku gululo "Magwiridwe oyambira".
4. Chongani bokosi pafupi "Onetsani tsamba la Wotsogolera mu nthiti".
5. Tabu imawonekera pazolamulira "Wopanga", pomwe katunduyo adzapezeke "Macros".
Kujambula Pamaso pa Macro
1. Pa tabu "Wopanga" kapena, kutengera mtundu wa Mawu omwe agwiritsidwa ntchito, tabu "Onani"kanikizani batani "Macros" ndikusankha "Kulemba Zinthu Pamanja".
2. Fotokozani dzina la macro kuti apangidwe.
Chidziwitso: Ngati inu, mukapanga macro atsopano, apatseni ndendende dzina lofananalo ndi zomwe zidalowetsedwa, zomwe mudalemba mu macro atsopano zichitike m'malo mwa yokhazikika. Kuti muwone macro akupezeka mu MS Word mosaphonya mndandanda wa batani "Macros" sankhani "Malangizo A Mawu".
3. M'ndime "Macro akupezeka" sankhani zomwe zingapezeke: template kapena chikalata chomwe mungasungiremo.
- Malangizo: Ngati mukufuna kuti ma macro opangidwa azikhala muzolemba zonse zomwe mukugwira nawo mtsogolo, sankhani "Yachika.dotm".
4. M'munda "Kulongosola" lembani tanthauzo la macro kuti apangidwe.
5. Chitani chimodzi mwanjira zotsatirazi:
- Dinani “Batani”;
- Sankhani chikalata chomwe mukufuna kuwonjezera pa zomwe zidapangidwa kuti zizipezeka mwachangu (gawo "Kusintha Chida Chachangu");
- Malangizo: Kuti opanga opanga onse azitha kupeza zolemba zonse, sankhani "Yachika.dotm".
Pazenera "Macro of" (kale "Sankhani magulu kuchokera") sankhani zazikulu zomwe mukufuna kujambula, dinani Onjezani.
- Ngati mukufuna kusintha batani ili, dinani “Sinthani”;
- Sankhani chizindikiro choyenera kuti batani lipangidwe m'munda Chizindikiro;
- Lowetsani dzina la ma macro, omwe adzawonetsedwa pambuyo pake m'munda “Sonyezani Dzina”;
- Kuti muyambe kujambula zazikulu, dinani kawiri batani "Zabwino".
Khalidwe lomwe mwasankha liziwonetsedwa mu chida chofikira mwachangu. Mukasuntha pachikhalidwe ichi, dzina lake liziwonetsedwa.
- Dinani batani “Mfungulo” (kale "Kiyibodi");
- Mu gawo “Magulu” sankhani zazikulu zomwe mukufuna kujambula;
- Mu gawo "Short keyboard" lowetsani zosakaniza zilizonse zosavuta kwa inu, kenako ndikanikizani batani “Gawani”;
- Kuyambitsa kujambula zazikulu, dinani “Yandikirani”.
6. Chitani zochitika zonse zomwe mukufuna kuphatikiza mu zazikulu, imodzi.
Chidziwitso: Pojambula mbali zazikulu kwambiri, simungagwiritse ntchito mbewa kuti musankhe mawu, koma muyenera kugwiritsa ntchito posankha malamulo ndi magawo ake. Ngati ndi kotheka, mutha kusankha mawu pogwiritsa ntchito kiyibodi.
Phunziro: Ma Hotkeys mu Mawu
7. Kuyimitsa kujambula macro, akanikizire "Siyani kujambula", lamuloli likupezeka pazosankha batani "Macros" pagulu lolamulira.
Sinthani tatifupi ya kiyibodi yamalonda
1. Tsegulani zenera “Zosankha” (menyu "Fayilo" kapena batani “Office Office”).
2. Sankhani "Konzani".
3. Dinani batani "Konzani"ili pafupi ndi munda "Njira yachidule".
4. Mu gawo “Magulu” sankhani "Macros".
5. Pamndandanda womwe umatsegulira, sankhani zazikulu zomwe mukufuna kusintha.
6. Dinani pamunda "Short keyboard" ndikusindikiza makiyi kapena kiyi yophatikizira yomwe mukufuna kupatsa mtundu wina.
7. Onetsetsani kuti chophatikiza chomwe mwapereka sichikugwiritsidwa ntchito kuti mugwire ntchito ina (gawo "Kuphatikiza kwaposachedwa").
8. Mu gawo “Sungani Zomwe Mwasintha” sankhani njira yoyenera (malo) kuti musunge malo omwe macro azidzayendetsedwa.
- Malangizo: Ngati mukufuna kuti ma macro apezeke kuti agwiritsidwe ntchito pamapepala onse, sankhani "Yachika.dotm".
9. Dinani “Yandikirani”.
Macro amathamanga
1. Kanikizani batani "Macros" (tabu "Onani" kapena "Wopanga", kutengera mtundu wa pulogalamu yomwe idagwiritsidwa ntchito).
2. Sankhani zazikulu zomwe mukufuna kuthamanga (mndandanda “Dzina Lalikulu”).
3. Dinani Thawani.
Pangani macro yatsopano
1. Kanikizani batani "Macros".
2. Fotokozani dzina la macro atsopano mundawo lolingana.
3. Mu gawo "Macros kuchokera" sankhani template kapena pepala lomwe ma macro omwe amapangidwawo asungidwa.
- Malangizo: Ngati mukufuna kuti ma macro apezeke m'malemba onse, sankhani "Yachika.dotm".
4. Dinani Pangani. Mkonzi atsegula Zowoneka zoyambira, momwe mungapangire Macro atsopano mu Visual Basic.
Ndizo zonse, tsopano mukudziwa zomwe ma macros ali mu MS Mawu, chifukwa chake amafunikira, momwe angapangire ndi momwe angagwirire nawo. Tikukhulupirira kuti chidziwitso munkhaniyi chikhala chothandiza kwa inu ndikuthandiziradi kuti muchepetse, kufulumizitsa ntchito ndi pulogalamu yapamwamba yaofesi.