- Amamakhro akuvumela ukuthi wenze ngokuzenzakalelayo imisebenzi ephindaphindwayo ku-Excel usebenzisa i-Visual Basic for Applications (VBA).
- Ungarekhoda, uqalise, futhi uhlele amamakhro kusuka kuthebhu kanjiniyela ukuze uthuthukise ukuhamba kwakho komsebenzi.
- Ukusebenzisa ama-macros ne-VBA kusiza ukunciphisa amaphutha, ukuthuthukisa ukukhiqiza, nokwenza ngendlela oyifisayo imisebenzi ku-Excel.
- Kubalulekile ukuhlola nokwenza kahle ama-macros ukuze uqinisekise ukuthi asebenza kahle ngenani elikhulu ledatha.
I-Microsoft Excel ingenye yamathuluzi asetshenziswa kakhulu emhlabeni ekuphathweni nasekuhlaziyweni kwedatha. Kodwa-ke, ukwenza imisebenzi ephindaphindwayo ku-Excel kungaba yinto ekhathazayo futhi edla isikhathi. Yilapho ama-macro kanye ne -Visual Basic for Applications (VBA) zingena khona , amathuluzi akuvumela ukuthi wenze izinqubo ngokuzenzakalelayo futhi uthuthukise umkhiqizo.
Uma ufuna ukufunda ukuthi imisebenzi izenzekela kanjani ku-Excel, lesi sihloko sizokunikeza lonke ulwazi oludingekayo. Lapha uzothola ukuthi ama-macro asebenza kanjani, ukuthi uwaqopha kanjani , uwahlele kanjani , futhi uwalungiselele kanjani ukuze wenze umsebenzi wakho we-Excel usebenze kahle kakhulu.
Ayini ama-macros ku-Excel?
Ama-Macro ku-Excel ayizilandelaniso zemiyalelo ezenza imisebenzi ethile isebenze ngokuzenzakalela ngaphakathi kwespredishithi. Le miyalelo ingasukela ekubaleni okuyisisekelo kuya emisebenzini eyinkimbinkimbi njengokuphathwa kwedatha, ukukhiqizwa kwemibiko, kanye nokusebenzisana nezinye izinhlelo zokusebenza ze-Microsoft Office.
Ama-Macro adalwa kusetshenziswa ulimi lokuhlela lwe -Visual Basic for Applications (VBA) . Lokhu kuvumela abasebenzisi ukuthi babhale ikhodi yangokwezifiso ukuze benze izinqubo ngokuzenzakalela ku-Excel, banciphise isikhathi somsebenzi futhi banciphise amaphutha.
Izinzuzo zokusebenzisa ama-macros ku-Excel
- Isikhathi sokulondoloza: Ikuvumela ukuthi wenze imisebenzi ephindaphindayo ngemizuzwana esikhundleni sokuyenza mathupha.
- Ukwehliswa kwephutha: Izinqubo zokuzenzakalela zinciphisa amaphutha abantu ekuphathweni kwedatha.
- Ukusebenza kahle okukhulu: Isiza ukuphatha kanye nokuhlaziywa kwenqwaba yolwazi.
- Personalización: Inika amandla ukudalwa kwamathuluzi athile afanelana nezidingo zomsebenzisi.
Unganika amandla kanjani ithebhu kanjiniyela ku-Excel
Ngaphambi kokuthi uqale ukusebenza ngama-macro, udinga ukuvula ithebhu yonjiniyela ku-Excel. Ukuze wenze lokhu, landela lezi zinyathelo:
- Vula i-Excel bese uchofoza Faka kungobo yomlando > Izinketho.
- Kumenyu eseceleni, khetha Yenza iribhoni ngendlela oyifisayo.
- Ohlwini lwamathebhu atholakalayo, hlola inketho Unjiniyela.
- Qhafaza ukwamukela ukusindisa izinguquko.
Ungarekhoda kanjani i-macro ku-Excel
Uma ungakaze usebenze ngama-macro, indlela elula yokuqala ukuqopha eyodwa . I-macro recorder ithwebula yonke into oyenzayo ku-Excel bese iyiguqula ibe yikhodi ye-VBA ongayisebenzisa ngokuzenzakalelayo.
- Iya kuthebhu Unjiniyela bese uchofoza Qopha imakhro.
- Faka igama lemakhro futhi, ngokukhetha, nokhiye wesinqamuleli ukuze uyiqalise ngokushesha.
- Yenza izenzo ofuna ukuzenza ngokuzenzakalelayo.
- Uma usuqedile, chofoza Misa ukuqopha.
Ungayisebenzisa kanjani i-macro ku-Excel
Uma usuqophe i-macro, ungayiqhuba kalula ngokulandela lezi zinyathelo:
- Iya kuthebhu Unjiniyela bese uchofoza amamakhro.
- Khetha imakhro ofuna ukuyisebenzisa.
- Chofoza inkinobho Gijima.
Ungayihlela kanjani i-macro ku-Visual Basic (VBA) Editor
Uma udinga ukwenza izinguquko ku-macro eqoshiwe noma ufuna ukubhala eyodwa kusukela ekuqaleni, ungakwenza lokho kusuka ku- Visual Basic Editor (VBE) . Ukuze uyifinyelele:
- Iya kuthebhu Unjiniyela bese uchofoza Visual Basic.
- Kumhleli, khetha i-macro ofuna ukuyishintsha.
- Yenza izinguquko kukhodi bese ulondoloza ifayela.
Isibonelo sekhodi ye-VBA ukuze wenze umsebenzi ngokuzenzakalelayo
Uma ufuna ukubhala i-macro kusuka ekuqaleni, nasi isibonelo sekhodi ye-VBA ekopisha idatha eshidini elilodwa bese iyinamathisela kwelinye:
I-Sub CopyData() AmaSpredishithi("Ishidi1").Ububanzi("A1:D10").Kopisha AmaSpredishithi("Ishidi2").Ububanzi("A1").Namathisela UkunamathiselaOkukhethekile:=xlPasteValues Application.CutCopyMode = Isiphetho Samanga Esingaphansi
Amathiphu okuthuthukisa ukusetshenziswa kwama-macros ku-Excel
- Hlukanisa imisebenzi ibe amamakhro amancane: Isebenza kangcono kune-macro ende, eyinkimbinkimbi.
- Sebenzisa amazwana kukhodi: Kwenza ikhodi iqondeke kalula futhi igcinwe.
- Londoloza amakhophi ayisipele: Ngaphambi kokusebenzisa imakhro, gcina ikhophi yefayela lakho langempela.
- Hlola amamakhro kumafayela okuhlola: Qiniseka ukuthi zisebenza kahle ngaphambi kokuzisebenzisa emibhalweni ebalulekile.
Ukwazi ama-macro kanye ne-VBA ku-Excel kuzoba usizo kakhulu kunoma iyiphi indawo yokusebenza lapho ukuphathwa kwedatha kubalulekile khona. Ngalolu lwazi, ungenza imisebenzi ejwayelekile ibe ngokuzenzakalelayo futhi uthuthukise kakhulu umkhiqizo wakho.
Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.