I-Microsoft Excel sisixhobo esingaphezulu kunesiluncedo ekungaziwa kwayo okungazange kwaliwe iminyaka emininzi. Ibalulekile kubomi bomsebenzi kunye nabucala.

Ngokongeza ikhowudi yeVBA kwiifayile zakho, unokwenza imisebenzi emininzi kwaye ugcine ixesha elininzi.

Le khosi yasimahla ikubonisa indlela yokungena ngexesha ngokuzenzekelayo. Kwaye ukwenza njani ukusebenza ngokukhawuleza kwaye kulula kangangoko ngolwimi lweVBA.

Ikhwizi ozikhethelayo iya kukuvumela ukuba uvavanye izakhono zakho ezintsha.

Yintoni iVBA kwaye kutheni siyisebenzisa?

I-VBA (Visual Basic for Applications) lulwimi lokuprograma olusetyenziswa kuzo zonke ii-Microsoft Office (ngoku eziyi-Microsoft 365) izicelo (iWord, Excel, PowerPoint, ne-Outlook).

Ekuqaleni, iVBA yayikukuphunyezwa kolwimi lweMicrosoft Visual Basic (VB) olufumaneka kwii-aplikeshini ze-Microsoft Office. Nangona ezi lwimi zimbini zihlobene ngokusondeleyo, umahluko omkhulu kukuba ulwimi lweVBA lunokusetyenziswa kuphela kwizicelo zeOfisi yeMicrosoft.

Ngombulelo kolu lwimi lulula, unokwenza iinkqubo zekhompyuter ezintsonkothe ​​ngakumbi okanye ezingaphantsi ezenza imisebenzi ephindaphindwayo okanye wenze inani elikhulu lemisebenzi usebenzisa umyalelo omnye.

Ngeyona ndlela ilula, ezi nkqubo zincinci zibizwa ngokuba yi-macros kwaye zizikripthi ezibhalwe ngabaprogram be-VBA okanye ezicwangciswe ngumsebenzisi. Zingaphunyezwa ngebhodi enye okanye umyalelo we mouse.

Kwiinguqulelo ezinzima ngakumbi, iinkqubo ze-VBA zinokusekelwe kwizicelo ezithile ze-Ofisi.

I-algorithms ingasetyenziselwa ukuvelisa ngokuzenzekelayo iingxelo, uluhlu lwedatha, ii-imeyile, njl. Ungasebenzisa i-VBA ukwenza izicelo zoshishino ezineenkcukacha ezisekelwe kwizicelo eziqhelekileyo ze-Ofisi.

Nangona i-VBA okwangoku ilinganiselwe kubadwelisi abanamava, ukufikeleleka kwayo, ukusebenza okutyebileyo kunye nokuguquguquka okukhulu kusenomtsalane kwiingcali ezininzi, ngakumbi kwishishini lezemali.

Sebenzisa irekhoda enkulu kwindalo yakho yokuqala

Ukwenza i-macros, kufuneka ikhowudi iprogram ye-Visual Basic (VBA), eyona nto irekhodiweyo enkulu, ngokuthe ngqo kwisixhobo esibonelelwe oku. Ayinguye wonke umntu oyisazi sekhompyuter, ke nantsi indlela yokuseta ii-macros ngaphandle kokucwangcisa.

– Cofa kwisithuba Umthuthukisi, emva koko iqhosha irekhodi i-macro.

- Endle igama elikhulu, chwetheza igama ofuna ukulinika i-macro yakho.

Kwintsimi Iqhosha elinqumlayo, khetha indibaniselwano yesitshixo njengendlela emfutshane.

Chwetheza inkcazelo. Ukuba unemacro erekhodiweyo engaphezulu kwesinye, sicebisa ukuba uzibize zonke ngokuchanekileyo ukunqanda ukusetyenziswa kakubi.

– Cofa Kulungile.

Yenza zonke iintshukumo ofuna ukuzicwangcisa usebenzisa i-macro.

– Buyela emva kwithebhu Umthuthukisi kwaye ucofe kwiqhosha Yeka ukurekhoda wakube ugqibile.

Lo msebenzi ulula, kodwa ufuna ukulungiswa. Esi sixhobo sikhuphela zonke iintshukumo ozenzayo ngelixa urekhoda.

Ukuze ugweme iimeko ezingalindelekanga, kufuneka wenze zonke izenzo eziyimfuneko ukuze i-macro isebenze (umzekelo, ukucima idatha endala ekuqaleni kwe-macro) ngaphambi kokuba uqale ukurekhoda.

Ngaba iimacros ziyingozi?

Imacro eyenzelwe uxwebhu lwe-Excel ngomnye umsebenzisi ayikhuselekanga. Isizathu silula kakhulu. Abahlaseli banokwenza iimacros ezinobungozi ngokuguqula okwethutyana ikhowudi yeVBA. Ukuba ixhoba livula ifayile eyosulelekileyo, iOfisi kunye nekhompyuter inokosuleleka. Ngokomzekelo, ikhowudi inokungena kwisicelo se-Ofisi kwaye isasaze rhoqo xa ifayile entsha yenziwe. Kwimeko embi kakhulu, inokungena kwibhokisi yakho yeposi kwaye ithumele iikopi zeefayile ezinobungozi kwabanye abasebenzisi.

Ndinokuzikhusela njani kwiimacros eziyingozi?

IiMacros ziluncedo, kodwa zisesichengeni kakhulu kwaye zinokuba sisixhobo sabahlaseli ukusasaza i-malware. Nangona kunjalo, unokuzikhusela ngokufanelekileyo. Iinkampani ezininzi, eziquka uMicrosoft, ziphucule ukhuseleko lwezicelo zazo kule minyaka idlulileyo. Qinisekisa ukuba oluphawu luvuliwe. Ukuba uzama ukuvula ifayile equlethe i-macro, isofthiwe iya kuyivimba kwaye ikulumkise.

Ingcebiso ebaluleke kakhulu yokuphepha imigibe yabahlaseli akuyikukhuphela iifayile kwimithombo engaziwayo. Kwakhona kubalulekile ukukhawulela ukuvulwa kweefayile eziqulethe ii-macros ukwenzela ukuba kuphela iifayile ezithembekileyo zingavulwa.

 

Qhubeka ufunda inqaku kwindawo yokuqala →