Excel macros - kuchengetedza nguva yako

Mu Excel, maShoko uye Power Point mapikicha, unogona kuumba mirairo yako, inonzi macros. Vanoita basa rekuita basa, kana iwe uchifanira kushandisa nguva dzose kutumira mameseji kana kushandura maitiro akafanana, kupinda mahedheni akafanana ezvigadzirwa, nezvimwewo. Ichokwadi, macros mapurogiramu maduku, sezvo akanyorwa muVisual Basic scripts. Zvisinei, kunyange munhu anoshanda ari kure nemapurogiramu anogona kuzvigadzira nekugadzirisa nyore nyore.

Excel macros inowanzoshandiswa. Nekubatsira kwavo, unokwanisa kutora zvinyorwa zvekuverengera, somuenzaniso, kuverenga bhajeti yemwedzi wegore.

Kunyora macro

Unogona kugadzira macro munzira mbiri. Yokutanga ndyo kunyora script VB kubva pakutanga. Ndizvo mapurogiramu anoita. Nzira yechipiri iri nyore: unofanirwa kubvumira kurega kwezviito zvose mune rimwe rerekodhi uye kamwechete zvakare kuita maitiro aunoda kuita.

Ngatitarise kuti tinganyora sei macros muna Excel 2007 tichishandisa macro recorder (nzira yechipiri). Izvo zvigadzirwa zvinoshandiswa zviri mu "Nyanzvirudzi" tab. Kubvira pakatarisa tab kazhinji haisi kuratidzirwa, iwe kutanga unoda kuenda kumapurogiramu ekushandiswa. Kuti uite izvi, svinura bhokota yakapoteredza neka logo yeMicrosoft uye sarudza "Excel Options". Zvadaro, "Zvirongwa zveMunhu", "Basic Settings ...", sarudza bhokisi rekutarisa riri pedyo nechimwe chinhu chinotarisirwa kuratidza tab yaunoda.
Kuti uite itsva Excel macros, unoda zvinotevera:

• Vhura Developer> Code> Rekodi Macro.
• Nyora pasi zita iro richave rakanyatsojekesa kuti macro inobata sei.
• Sarudza kiyi yakakodzera yekubatanidzwa kwekukurumidza kwekushevedza kukuru (haifaniri kudzokorora yako inoshandiswa yeWindows hot keys, somuenzaniso, CTRL + C / CTRL + V).
• Iko "Ponesa kune ..." rondedzero inotarisa kuwanda kwema macro. Kuti yako Excel macros inoshanda mumagwaro ose akazarurwa pakombiyuta iyi, sarudza "Bhuku Rebhuku".
• Dzadza tsanangudzo (nyorai zviito zvose zvakanyorwa).
• Dzvanya "OK" kuti utange kunyora. Chiratidzo chinonyanya kuonekwa mukona yekona.
• Ita zviito zvakakosha nemasero.
• Dzvanya "Rega kutora" mu "Developer"> "Code" tab.

Cherechedza: Excel macros inogona kuchengetedza chiyero kana zvachose zvinyorwa. Kana iwe usina kusarudza sarudzo yakakodzera, panguva yekunyora, macro ichayeuka kuti chiito chinofanira kushandiswa kusero rawakasarudza. Kana iwe unofanirwa kushanda nemasero akasiyana, sarudza sarudzo pamusoro pehukama hukama.

Kushanda pamwe nemarongwa epurogiramu (switching tabs) uye kushandura kune mamwe mahwindo murekodha haina kunyorwa.

Zvichengetedza Zvirongwa

Pasinei nekusimbiswa kwekuti shanduro inogona kuzvimirira zvakasarudzwa kuti ione macros nokuda kwekodhi yakaipa, haisati yakurudzirwa kuti ivatore kubva pane zvisingazivikanwi. Somuenzaniso, download yakagadzirira kubva paInternet. Iwe unogona kuvimba nemaonero evantivirusi, uye macros anoshandiswa pamakombiyuta akawanda muhofisi anokurudzirwa kuti ave nesayini yakasayinwa.

Nokusingaperi, kushandiswa kwe macros mumabhuku kunowanzoremara. Iwe unogona kubvumira macro macros kana uchienda kuMusikirusi tab uye enda kuCode> Macro Security> Macro Options> Ita zvose> OK. Iko kushandurwa kunotanga kuitika panguva inotevera faira yakazaruka.