Kubatsira kweVBA programmer

Kana iwe uchitaura izwi rekuti "macros" nemweya wekutyisa uye chirevo pane yechipiri syllable, uye mutsara wekuti "Visual Basic for Applications" unonzwika sechiperengo kwauri, saka chinyorwa ichi hachisi chako. Chero zvazvingava, ikozvino 🙂

Kana iwe uine ruzivo rwakakwana mukuronga macros muVBA muExcel, uye iwe usingaronge kumira, saka kusarudzwa kweanobatsira ekuwedzera uye zvirongwa pazasi kunofanirwa kuve (zvishoma zvishoma) kunobatsira kwauri.

MZ-Zvishandiso - "Swiss banga" kune programmer

Mushure mekuisa muVBE mupepeti mune menyu midziyo submenu ichaonekwa MZ-Zvishandiso uye new toolbar yekukurumidza kuwana kune mamwe mabasa:

Anoziva kuita zvakawanda. Pakati pezvakanyanya kukosha, mumaonero angu:

• Wedzera otomatiki "hove isina chinhu" kugadzira maitiro, mashandiro, chiitiko uye zvikanganiso zvibatiso nemazita emhando yemhando zvinoenderana neHungarian system.
  
• Kopa zvidzoreso pamafomu evashandisi pamwe nekodhi yavo.
  
• Gadzira mabhukimaki (Favorites) emaitiro uye nekukurumidza uende kwavari mune yakakura purojekiti.
• Kamura mitsetse mirefu yekodhi kuita akati wandei uye uunganidze kumashure (kupatsanura uye sanganisa mitsetse).
  
• Bvisa huwandu hwehuwandu hwepurojekiti (nhamba yemitsara yekodhi, maitiro, zvinhu pamafomu, nezvimwewo)
• Tarisa purojekiti yezvakasiyana zvisina kushandiswa uye maitiro (Ongororo Kwakabva)
• Gadzira yako yega base yekodhi templates (Code Matemplate) emakesi akajairwa uye nekukurumidza uaise mumakros matsva gare gare.
• Gadzira otomatiki tambo refu uye inotyisa yekubatanidza kune ekunze data masosi kuburikidza neADO.
  
• Batanidza hotkeys kune chero basa kubva kune-add-on.
  

Chinhu chisina kujeka chinofanira-kuve nacho chemugadziri wechero nhanho. Kana uine yazvino vhezheni yeHofisi, saka iva nechokwadi chekudhawunirodha yazvino vhezheni yeMZ-Tools 3.00.1218 yaMarch 1, nekuti. yakagadzirisa bug kana uchishanda neExcel 2013.  

Download linked MZ-Zvishandiso

Smart Indenter - otomatiki indentation mune kodhi

Inoita basa rimwechete rakareruka asi rinonyanya kukosha - rinongoisa ma tabo muVBA kodhi, richinyatso ratidza zvishwe zvakaiswa, macheki emamiriro, nezvimwe.

Zviri nyore kupa chiitiko ichi kune chero yakanakira keyboard nzira muchikamu Indenting Options uye zviite nekubata kumwe chete.

Nehurombo, munyori wechirongwa akaisiya muna 2005 (nei, Carl!?) uye yazvino vhezheni pane saiti ndeyeExcel 97-2003. Nekudaro, chirongwa ichi chinoshanda chaizvo nemavhezheni matsva. Iyo chete caveat: kana uine Excel 2013, saka usati waisa Smart Indenter, unofanira kutanga waisa yazvino vhezheni yeMZ-Tools, nekuti. ine raibhurari ine simba inodiwa pabasa reInterter.

Download linked Smart Indenter

VBE Zvishandiso - micro-tuning zvinhu mumafomu

Kugadzirisa zvigadziriso (mabhatani, minda yekupinza, zvinyorwa zvinyorwa, nezvimwewo) pane fomu yakaoma inogona kurwadza mbongoro. Yakajairika inosunga kune iyo edhita grid kuburikidza nemenyu Zvishandiso - Sarudzo - Zvakawanda - Rongedza Zvidzore kuGridhi dzimwe nguva hazvibatsiri zvakanyanya uye zvinototanga kupinda munzira, kunyanya kana iwe uchida kufamba, semuenzaniso, bhatani zvishoma. Iyo VBE Zvishandiso yekuwedzera ichabatsira mune iyi nyaya, iyo, mushure mekuiswa, inoratidza iri nyore pani paunogona kunyatso-tuta saizi uye chinzvimbo pafomu yechinhu chakasarudzwa:

Kuchinja kwenzvimbo kunogonawo kuitwa neAlt+miseve, uye kudzoreredza neShift+Alt+miseve uye Ctrl+Alt+miseve.

Zvakare, nekudzvanya-kurudyi pane chimwe chinhu, unogona kuchitumidza zvakare nekukurumidza pamwe nekodhi.

Download linked VBE Zvishandiso

VBA Diff - Kutsvaga Misiyano muCode

Ichi chishandiso chingangonyanya kubatsira kune nyanzvi VBA programmers pakugadzira mapurojekiti makuru uye akaomarara kana kudyidzana kusimudzira. Basa rayo guru nderekuenzanisa mapurojekiti maviri uye nekuona mutsauko wekodhi pakati pavo:

Kune mazuva makumi matatu emahara nguva, uye ipapo iyo yekuwedzera ichakukumbira kuti ubhadhare 30 pounds pairi (inenge 39 zviuru rubles pamutengo wekuchinjana ikozvino).

Kutaura chokwadi, zvakauya zvakanaka muhupenyu hwangu chete 3-4 nguva pamapurojekiti akakura, asi zvakazondiponesa mazuva akati wandei uye akawanda etsinga masero 🙂 Zvakanaka, pane nguva dzose, hongu, imwe yemahara imwe nzira: kunze kwenyika kodhi kune chinyorwa faira (kurudyi-tinya modulo - ekisipoti) wozvienzanisa gare gare muMicrosoft Word uchishandisa murairo Ongorora - Enzanisa Zvinyorwa, asi nerubatsiro rweVBA Diff iri kurongeka kwehukuru huri nyore.

Download linked VBA Diff

Moqups uye Wireframe Sketcher - interface prototyping

Paunenge uchigadzira nzvimbo dzakaomarara dzekudyidzana kwevashandisi, zviri nyore kugadzira kumberi kutaridzika kutaridzika kwemabhokisi e dialog, kureva kuita. Prototyping. Muchokwadi, zvinova zviri nyore pane kudzoreredza mafomu akagadzirwa uye kodhi yavo gare gare. Ndinoyeuka kamwe mune rimwe remapurojekiti mutengi akakumbira kugadzira "menyu", zvichireva "matabo". Half a day of work down the drain 🙁

Kune huwandu hukuru hweakabhadharwa uye emahara zvirongwa zveakasiyana mazinga ekuomarara uye simba reaya mabasa. Ndakaedza anenge gumi nemaviri mapurogiramu akadai nemasevhisi, uye munguva pfupi yapfuura ini ndinowanzo shandisa moqups:

Uyu mupepeti wepamhepo uyo:

• Hazvidi kuiswa kwemapurogiramu akasiyana. Iwe unogona kugara uchiuya kuhofisi yemutengi uye yakavhurika-show-kururamisa iyo yakagadzirwa interface chaipo pane saiti.
• Ine zvese zvakakosha zvemabhokisi emabhokisi (mavara, mabhatani, rondedzero, nezvimwewo) mushanduro dzeWindows neMac.
• Inokutendera kuti utumire kunze iyo yakagadzirwa interface muPNG kana maPDF mafomati kana kutumira chinongedzo kune mutengi kuti utarise online.
  
• Chokwadi mahara. Pane miganho pahuwandu hwemifananidzo yezvinhu, asi ini handina kumbobvira ndakwanisa kupfuura iwo. Kana iwe ukapererwa nenzvimbo kana uchida kuchengetedza akati wandei mapurojekiti kamwechete, unogona kugara uchisimudzira kune iyo premium vhezheni yemadhora makumi mapfumbamwe nemapfumbamwe pagore.

Muzhinji, kune mabasa emugadziri muVBA - kupfuura zvakakwana, ndinofunga.

Kana paine chero munhu achinyatsoda sarudzo yekunze (kushanda pasina Internet pamahombekombe egungwa, semuenzaniso), ini ndinokurudzira Wireframe Sketcher:

Mushure menguva yemahara yedemo kwemavhiki maviri, achakukumbira kuti utenge neiyo $2 imwechete.

Link to moqups

Download linked Wireframe Sketcher

Invisible Basic - kodhi obfuscator

Nehurombo, hazvigoneke kukiya zvakachengeteka kodhi kodhi yemacros yako nepassword muMicrosoft Excel. Nekudaro, kune kirasi yese yemapurogiramu anonzi obfuscators (Kubva kuChirungu. kuvhiringika - kuvhiringa, kuvhiringa), iyo inoshandura chitarisiko cheVBA kodhi nenzira yekuti ichave yakaoma zvakanyanya kuiverenga nekuinzwisisa, zvinoti:

• mazita ezvakasiyana-siyana, maitiro uye mabasa anotsiviwa nemaseti marefu asina zvazvinoreva kana, ukuwo, nemazita mapfupi earufabheti asinganzwisisike.
  
• idents tabulation indents inobviswa
• anobviswa kana, ukuwo, kutsemuka kwemitsara kunoiswa zvisina tsarukano, nezvimwe.

Kutaura chokwadi, ini handisi munhu anoda kushandisa nzira idzi. Kunyanya, nePLEX, ndakafunga kuti zvingava nani kupa vatengi veiyo yakazara vhezheni yakavhurika, inonzwisisika uye ine mhinduro sosi kodhi - izvi zvinoratidzika kwandiri zvakanyanya. Zvakadaro, shamwari dzangu dzepurogiramu dzakagara dziine zviitiko apo chirongwa chakadaro chingave chinobatsira zvikuru (mugadziri akaita basa, asi mutengi haana kubhadhara, nezvimwewo) Saka kana uchichida, ziva kuti ungachiwana kupi. "Isu tiri vanhu vane runyararo, asi chitima chedu chezvombo ..." uye zvese izvo.

Download Invisible Basic

Code Cleaner - kodhi yekuchenesa

Muchiito chekushanda purojekiti (kunyanya kana yakakura uye yakareba), "marara" anotanga kuunganidza mumakodhi modules uye mafomu - zvimedu zveVBE editor service service inogona kutungamirira kune zvisingatarisirwi uye zvisingadiwi glitches. Utility Code Cleaner inochenesa muck iyi nenzira yakapusa asi yakavimbika: inotumira kunze kodhi kubva kumamodule kuenda kune mameseji mafaera, uye wozoipinza kunze zvakachena kumashure. Ndinokurudzira zvikuru kuti kana uchishanda pamapurojekiti makuru, nguva nenguva ita "kuchenesa" kwakadaro.

Download linked Code Cleaner

Ribhoni XML Mupepeti

Kana iwe uchida kugadzira yako tebhu ine mabhatani akanaka paExcel ribhoni yekumhanyisa macros ako, saka haugone kuita pasina interface XML faira mupepeti. Sezvineiwo, yakanyanya nyore uye ine simba nhasi chirongwa chepamba mune iyi nyaya. Ribhoni XML Mupepetiyakagadzirwa naMaxim Novikov.

Iyo software yakanaka kwazvo iyo:

• zvinokutendera kuti uwedzere nyore ako ega mabhatani, mabhatani ekudonhedza pasi uye zvimwe zvinhu zveiyo itsva Office interface kune ribhoni.
• inotsigira zvizere mutauro
• inobatsira nekugadzirisa nekuratidza zvirevo zvemamiriro ezvinhu
• zvinogona kuitwa nyore nyore nezvidzidzo
  
• zvachose vakasununguka

Download linked Ribhoni XML Mupepeti

PS

Kwemakore akawanda, Microsoft yakaramba ichifuratira VBA vagadziri, vachifunga nezvayo, sezviri pachena, semutauro wakaderera wechirongwa. Runyerekupe nguva nenguva runotsvedza kuti iyo inotevera vhezheni yeHofisi haichazove neVisual Basic kana ichatsiviwa neJavaScript. Shanduro nyowani dzeVisual Studio dzinobuda nguva nenguva nezvinhu zvitsva, uye mupepeti weVBE akanamatira muna 1997, achiri kutadza kupinza kodhi nematurusi akajairwa.

Muchokwadi, zviuru zvevanhu zviri kuchengetedza maawa nemazuva nekuda kweVBA programmers kugadzira macros kuita otomatiki zuva nezuva hofisi data data routines. Chero ani akaona kuti macro mumitsetse gumi yekodhi inotumira sei mafaira kuvatengi ve10 muhafu yeminiti, kutsiva maawa matatu ebasa reupenzi, achandinzwisisa 🙂

Uye zvimwe. 

Ese ezvirongwa zviri pamusoro isarudzo yangu pachangu uye kurudziro yangu zvichienderana neruzivo rwangu. Hapana wevanyori akandikumbira kushambadzira uye haana kuripa (uye ini ndaisazozvitora, pamusimboti). Kana iwe uine chimwe chinhu chekuwedzera kune rondedzero iri pamusoro - kugamuchirwa kune zvakataurwa, vanhu vanoonga havazorambi vari muchikwereti.