Microsoft Excel chishandiso chinopfuura chinobatsira chine mukurumbira usina kurambwa kwemakore mazhinji. Izvo zvakakosha muhupenyu hwehunyanzvi uye hwepachivande.

Nekuwedzera VBA kodhi kumafaira ako, unogona otomatiki mabasa mazhinji uye kuchengetedza nguva yakawanda.

Iyi yemahara kosi inokuratidza maitiro ekuita otomatiki yekupinda nguva. Uye maitiro ekuita kuti kuvhiyiwa kuve nekukurumidza uye nyore sezvinobvira neVBA mutauro.

Mubvunzo wesarudzo uchakubvumidza kuti uedze hunyanzvi hwako hutsva.

Chii chinonzi VBA uye nei tichiishandisa?

VBA (Visual Basic for Applications) ndiwo mutauro wepurogiramu unoshandiswa muMicrosoft Office yose (ikozvino Microsoft 365) zvikumbiro (Shoko, Excel, PowerPoint, uye Outlook).

Pakutanga, VBA yaive yekuitwa kweMicrosoft's Visual Basic (VB) mutauro wakawanikwa muMicrosoft Office application. Kunyangwe mitauro miviri iyi yakabatana zvakanyanya, musiyano mukuru ndewekuti mutauro weVBA unogona kungoshandiswa muMicrosoft Office application.

Nekuda kwemutauro wakapfava uyu, unogona kugadzira zvimwe kana zvishoma zvakaoma komputa zvirongwa zvinodzokorodza otomatiki mabasa kana kuita nhamba huru yekushanda uchishandisa murairo mumwe chete.

Mune chimiro chavo chakareruka, zvirongwa zvidiki izvi zvinonzi macros uye zvinyorwa zvakanyorwa neVBA programmers kana kurongwa nemushandisi. Ivo vanogona kuurayiwa nekamwechete keyboard kana mbeva command.

Mune mamwe mavhezheni akaomarara, zvirongwa zveVBA zvinogona kuve zvichibva pane chaiyo Office application.

Algorithms inogona kushandiswa kugadzira otomatiki mishumo, rondedzero yedata, maemail, nezvimwe. Iwe unogona kushandisa VBA kugadzira yakadzama bhizinesi zvikumbiro zvinoenderana neyakajairwa Office application.

Kunyangwe hazvo VBA parizvino yakaganhurirwa kune vane ruzivo vanogadzira mapurogiramu, kuwanikwa kwayo, kushanda kwakapfuma uye kuchinjika kukuru kuchiri kukwezva nyanzvi dzakawanda, kunyanya muindasitiri yezvemari.

Shandisa macro rekodhi kune ako ekutanga zvisikwa

Kuti ugadzire macros, unofanirwa kukodha a Visual Basic (VBA) chirongwa, chiri chokwadi kurekodha macro, zvakananga muchishandiso chakapihwa ichi. Haasi munhu wese musayendisiti wekombuta, saka heino maitiro ekumisikidza macros pasina kuronga iwo.

- Dzvanya pane iyo tab Mugadziri, bhatani bhatani rekodhi a macro.

- Mumunda macro name, nyora zita raunoda kupa kune yako macro.

Mumunda Shortcut kiyi, sarudza musanganiswa wakakosha senzira yekudimbudzira.

Nyora tsananguro. Kana iwe uine anopfuura macro imwe akarekodhwa, tinokurudzira kuti uzvipe mazita ese nemazvo kudzivirira kushandiswa zvisizvo.

– Dzvanya OK.

Ita zviito zvese zvaunoda kuronga uchishandisa macro.

- Dzokera kune tab Mugadziri uye tinya pamusoro bhatani Mira kurekodha kana wapedza.

Kuvhiya uku kuri nyore, asi kunoda kugadzirira. Ichi chishandiso chinokopa zvese zvaunoita paunenge uchirekodha.

Kuti udzivise mamiriro asingatarisirwi, iwe unofanirwa kuita zvese zvinodikanwa kuti macro ishande (semuenzaniso, kudzima data rekare pakutanga kwe macro) usati watanga kurekodha.

Macros ane ngozi here?

Iyo macro yakagadzirirwa gwaro reExcel nemumwe mushandisi haina kuchengetedzeka. Chikonzero chiri nyore kwazvo. Hackers vanogona kugadzira macros ane hutsinye nekugadzirisa kwenguva pfupi VBA kodhi. Kana akabatwa akavhura faira rine hutachiona, Hofisi uye komputa inogona kutapukirwa. Semuenzaniso, iyo kodhi inogona kupinza iyo Office application uye inopararira nguva imwe neimwe iyo faira nyowani inogadzirwa. Munyaya yakaipisisa, inogona kupinza bhokisi rako retsamba uye kutumira makopi emafaira akashata kune vamwe vashandisi.

Ndingazvidzivirira sei kubva kune zvakaipa macros?

Macros anobatsira, asi zvakare ari panjodzi uye anogona kuve chishandiso chevanobira kuparadzira malware. Zvisinei, unogona kuzvidzivirira zvinobudirira. Makambani mazhinji, kusanganisira Microsoft, akavandudza chengetedzo yavo yekushandisa mumakore apfuura. Ita shuwa kuti chikamu ichi chakabatidzwa. Kana ukayedza kuvhura faira rine macro, software yacho inoivharira nekukuyambira.

Iyo yakanyanya kukosha matipi yekudzivirira misungo yevabiki haisi yekurodha mafaera kubva kusingazivikanwe masosi. Izvo zvakakoshawo kurambidza kuvhurwa kwemafaira ane macros kuitira kuti mafaira akavimbika chete avhurwe.

 

Ramba uchiverenga chinyorwa pane yekutanga saiti →