Ukusebenziseka komhleli we-VBA

Uma uphimisa igama elithi "macros" ngomoya othusayo kanye nokugcizelela kuhlamvu lwesibili, futhi inkulumo ethi "Visual Basic for Applications" izwakala njengesipelingi kuwe, khona-ke lesi sihloko akusona esakho. Kunoma yikuphi, okwamanje 🙂

Uma okungenani unolwazi oluthile lokuhlela ama-macros ku-VBA ku-Excel, futhi awuhleli ukumisa, khona-ke ukukhethwa kwezengezo eziwusizo nezinhlelo ezingezansi kufanele kube (okungenani ingxenye) kube usizo kuwe.

I-MZ-Tools – “ummese we-Swiss” womhleli

Ngemva kokufakwa kumhleli we-VBE kumenyu Amathuluzi imenyu encane izovela Amathuluzi we-MZ kanye nebha yamathuluzi entsha yokufinyelela ngokushesha emisebenzini efanayo:

Uyazi ukwenza okuningi. Kokubaluleke kakhulu, ngombono wami:

• Engeza ngokuzenzakalelayo "inhlanzi engenalutho" ukuze udale izinqubo, imisebenzi, imicimbi kanye nezibambi zamaphutha ngokuqanjwa okufanele kwezinto eziguquguqukayo ngokuvumelana nesistimu yesiHungary.
  
• Kopisha izilawuli kumafomu abasebenzisi kanye namakhodi abo.
  
• Yenza amabhukumaka (Izintandokazi) ngezinqubo futhi uye kuwo ngokushesha kuphrojekthi enkulu.
• Hlukanisa imigqa emide yekhodi ibe eminingana bese uhlanganisa emuva (uhlukanise futhi uhlanganise imigqa).
  
• Khipha izibalo ezinemininingwane kuphrojekthi (inani lemigqa yekhodi, izinqubo, izici kumafomu, njll.)
• Hlola iphrojekthi ukuze uthole okuguquguqukayo okungasetshenzisiwe nezinqubo (Umthombo Wokubuyekeza)
• Dala isisekelo sakho sezifanekiso zekhodi (Izifanekiso Zekhodi) zamakesi ajwayelekile futhi uwafake ngokushesha kumamakhro amasha kamuva.
• Dala ngokuzenzakalelayo iyunithi yezinhlamvu ende neyesabekayo ukuze uxhume emithonjeni yedatha yangaphandle nge-ADO.
  
• Namathisela okhiye abashisayo kunoma yimuphi umsebenzi ovela kusengezo.
  

Okufanele ube nakho kumhleli wanoma yiliphi izinga. Uma unenguqulo yakamuva ye-Office, qiniseka ukuthi ulanda inguqulo yakamuva ye-MZ-Tools 3.00.1218 yamhla ziyi-1 kuNdasa, ngoba. ilungise iphutha ngenkathi isebenza ne-Excel 2013.  

Thwebula isixhumanisi Amathuluzi we-MZ

I-Smart Indenter – ukuhlehlisa okuzenzakalelayo kukhodi

Yenza umsebenzi owodwa olula kodwa odingekayo kahle - ihlehlisa ngokuzenzakalelayo amathebhu kukhodi ye-VBA, igqamisa ngokusobala izihibe ezifakwe esidlekeni, ukuhlola isimo, njll.

Kuhle kakhulu ukwabela lesi senzo kunoma yisiphi isinqamuleli sekhibhodi esikahle esigabeni Izinketho zokuhlehlisa futhi ukwenze ngokuthinta okukodwa.

Ngeshwa, umbhali wohlelo walushiya ngo-2005 (kungani, Carl!?) futhi inguqulo yakamuva kusayithi eye-Excel 97-2003. Nokho, uhlelo lusebenza kahle kakhulu ngezinguqulo ezintsha. Okuwukuphela kwe-caveat: uma une-Excel 2013, ngaphambi kokufaka i-Smart Indenter, kufanele uqale ufake inguqulo yakamuva ye-MZ-Tools, ngoba. iqukethe umtapo wolwazi oguqukayo odingekayo emsebenzini we-Indenter.

Thwebula isixhumanisi I-Smart Indenter

Amathuluzi e-VBE – izakhi zokulungisa izinto ezincane ngamafomu

Ukulawula ukuqondanisa (izinkinobho, izinkambu zokufaka, amalebula ombhalo, njll.) efomini eliyinkimbinkimbi kungaba buhlungu. Ukubophezela okujwayelekile kugridi yomhleli ngemenyu Amathuluzi — Izinketho — Okujwayelekile — Qondanisa Izilawuli Kugridi ngezinye izikhathi akusizi kakhulu futhi iqala ngisho nokungena endleleni, ikakhulukazi uma udinga ukuhambisa, isibonelo, inkinobho nje kancane. Isengezo se-VBE Tools sizosiza kule ndaba, okuthi, ngemva kokufakwa, kubonise iphaneli elula lapho ungakwazi ukulungisa kahle usayizi nokuma efomini lesici esikhethiwe:

Ukushintsha indawo kungenziwa futhi ngemicibisholo ye-Alt, futhi ushintshe usayizi ngemicibisholo ethi Shift+Alt+ kanye nemicibisholo ka-Ctrl+Alt.

Futhi, ngokuchofoza kwesokudla entweni, ungayiqamba kabusha ngokushesha kanye nekhodi.

Thwebula isixhumanisi Amathuluzi e-VBE

I-VBA Diff - Ukuthola Umehluko Kwikhodi

Leli thuluzi cishe lizoba usizo kakhulu kubahleli bezinhlelo ze-VBA abangochwepheshe lapho bedala amaphrojekthi amakhulu nayinkimbinkimbi noma ukuthuthukiswa okuhlanganyelwe. Umsebenzi wayo oyinhloko ukuqhathanisa amaphrojekthi amabili futhi ubonise umehluko wekhodi phakathi kwawo:

Kukhona isikhathi samahhala sezinsuku ezingama-30, bese isengezo sizokucela ukuthi ukhokhe amakhilogremu angama-39 (cishe ama-ruble ayizinkulungwane eziyi-3.5 ngenani lokushintshana lamanje).

Uma ngikhuluma iqiniso, kwaba usizo ekuphileni kwami ​​izikhathi ezingu-3-4 kuphela kumaphrojekthi amakhulu kakhulu, kodwa-ke kwangisindisa izinsuku ezimbalwa namangqamuzana ezinzwa amaningi 🙂 Yebo, kuhlale kukhona enye indlela yamahhala: thekelisa ngaphandle ikhodi efayeleni lombhalo (chofoza kwesokudla i-modulo - Thumela) futhi uziqhathanise kamuva ku-Microsoft Word usebenzisa umyalo Buyekeza - Qhathanisa Amadokhumenti, kodwa ngosizo lwe-VBA Diff kuwuhlelo lobukhulu olulula kakhulu.

Thwebula isixhumanisi I-VBA Diff

I-Moqups ne-Wireframe Sketcher - i-interface prototyping

Lapho udala izindawo zokusebenzelana eziyinkimbinkimbi zokusebenzelana komsebenzisi, kulula kakhulu ukuklama kusengaphambili ukubukeka okulinganiselwe kwamabhokisi ezingxoxo, okungukuthi ukwenza. i-prototyping. Eqinisweni, kuvele kulula kakhulu kunokwenza kabusha amafomu enziwe ngomumo kanye nekhodi yawo kamuva. Ngikhumbula kanye kwenye yamaphrojekthi ikhasimende lacela ukwenza “imenyu”, okusho ukuthi “amathebhu”. Uhhafu wosuku lomsebenzi wehlisa ipayipi 🙁

Kunenani elikhulu lezinhlelo ezikhokhelwayo nezimahhala zamazinga ahlukene obunkimbinkimbi namandla ale misebenzi. Ngizamile cishe izinhlelo nezinsizakalo ezinjalo eziyishumi nambili, futhi muva nje ngivame ukusebenzisa Ukuhamba:

Lesi isihleli se-inthanethi esithi:

• Ayidingi ukufakwa kwezinhlelo ezihlukene. Ungakwazi ukuza njalo ehhovisi leklayenti futhi uvule-uhlelo-ulungise isixhumi esibonakalayo esidaliwe khona kanye kusayithi.
• Iqukethe zonke izici eziyinhloko zamabhokisi ezingxoxo (amalebula, izinkinobho, uhlu, njll.) kuzinguqulo ze-Windows ne-Mac.
• Ikuvumela ukuthi uthumele isixhumi esibonakalayo esidaliwe ngefomethi ye-PNG noma ye-PDF noma uthumele isixhumanisi eklayentini ukuze sibukwe ku-inthanethi.
  
• Empeleni mahhala. Kunemikhawulo enanini lezinto ezinemifanekiso, kodwa angikaze ngikwazi ukweqa. Uma uphelelwa yisikhala noma ufuna ukugcina amaphrojekthi ambalwa amakhulu ngesikhathi esisodwa, ungakwazi ukuthuthukela enguqulweni yeprimiyamu ngo-$99 ngonyaka.

Ngokuvamile, ngenxa yemisebenzi yonjiniyela ku-VBA - ngaphezu kokwanele, ngicabanga.

Uma noma ubani ngokuyisisekelo edinga inketho engaxhunyiwe ku-inthanethi (ukusebenza ngaphandle kokufinyelela i-inthanethi ogwini lolwandle, isibonelo), ngincoma I-Wireframe Sketcher:

Ngemva kwesikhathi sedemo samahhala amaviki angu-2, uzokucela ukuthi uthenge nge-$99 efanayo.

Xhumanisa Ukuhamba

Thwebula isixhumanisi I-Wireframe Sketcher

Invisible Basic - ikhodi obfuscator

Ngeshwa, akunakwenzeka ukukhiya ngokuphephile ikhodi yomthombo yama-macros akho ngephasiwedi ku-Microsoft Excel. Nokho, kukhona ikilasi lonke lezinhlelo ezibizwa obfuscators (Kusuka esiNgisini. ophambanisayo - dida, dida), okushintsha ukubukeka kwekhodi ye-VBA ngendlela yokuthi kuzoba nzima kakhulu ukuyifunda nokuyiqonda, okungukuthi:

• amagama okuguquguqukayo, izinqubo nemisebenzi athathelwa indawo amasethi ezinhlamvu ezinde ezingasho lutho noma, ngokuphambene, ngamagama amafushane angaqondakali ezinhlamvu zamagama.
  
• ama-indenti ethebula elibonakalayo ayasuswa
• ziyasuswa noma, ngokuphambene, ukunqamuka kwemigqa kubekwa ngokungahleliwe, njll.

Eqinisweni, angiyena umuntu othanda ukusebenzisa lezi zindlela. Ikakhulukazi, nge-PLEX, nginqume ukuthi kungaba ngcono ukunikeza abathengi benguqulo ephelele ikhodi yomthombo evulekile, eqondakalayo futhi enamazwana - lokhu kubonakala kulungile kimi. Noma kunjalo, abahleli bezinhlelo engikanye nabo baye baba namacala kaningi lapho uhlelo olunjalo lungaba usizo kakhulu (umhleli wezinhlelo wenze umsebenzi, kodwa iklayenti alizange likhokhe, njll.) Ngakho-ke uma uludinga, yazi ukuthi ungalutholaphi. “Singabantu abanokuthula, kodwa isitimela sethu esihlomile…” nakho konke lokho.

Thwebula Isisekelo Esingabonakali

Isicoci sekhodi - ukuhlanza amakhodi

Enkambweni yokusebenza kuphrojekthi (ikakhulukazi uma inkulu futhi inde), "udoti" uqala ukuqoqa kumamojula wekhodi namafomu - izinsalela zolwazi lwenkonzo yomhleli we-VBE ezingaholela ekugwemeni okungalindelekile nokungafuneki. Isisetshenziswa Isicoci sekhodi ihlanza loludaka ngendlela elula kodwa enokwethenjelwa: ikhiphela ngaphandle ikhodi isuka kumamojula iye kumafayela ombhalo, bese iyingenisa ihlanzekile emuva. Ngincoma kakhulu ukuthi lapho usebenza kumaphrojekthi amakhulu, ngezikhathi ezithile wenze "ukuhlanza" okunjalo.

Thwebula isixhumanisi Isicoci sekhodi

I-Ribbon XML Editor

Uma ufuna ukudala ithebhu yakho ngezinkinobho ezinhle kuribhoni ye-Excel ukuze usebenzise ama-macros akho, awukwazi ukwenza ngaphandle kwesixhumi esibonakalayo somhleli wefayela le-XML. Nakanjani, elula kakhulu futhi enamandla namuhla uhlelo lwasekhaya mayelana nalokhu. I-Ribbon XML Editoreyenziwe nguMaxim Novikov.

Isoftware emangalisayo ukuthi:

• izokuvumela ukuthi wengeze kalula awakho amathebhu, izinkinobho, izinhlu zokudonsela phansi nezinye izici ze-Office entsha kuribhoni
• fully supports language
• isiza ngokuhlela ngokuveza amacebo anomongo
• kungenziwa kahle ngezifundo
  
• ngokuphelele mahhala

Thwebula isixhumanisi I-Ribbon XML Editor

PS

Iminyaka eminingi, iMicrosoft ishaye indiva ngokusobala abathuthukisi be-VBA, ibheka, ngokusobala, njengolimi lokuhlela olusezingeni eliphansi. Amahemuhemu ahlala eshabalala okuthi inguqulo elandelayo ye-Office ngeke isaba nayo i-Visual Basic noma izothathelwa indawo yi-JavaScript. Izinguqulo ezintsha ze-Visual Studio ziphuma njalo nezinto ezintsha, futhi umhleli we-VBE wayebambeke ngo-1997, engakwazi ukuhlehlisa ikhodi ngamathuluzi ajwayelekile.

Eqinisweni, izinkulungwane zabantu zonga amahora nezinsuku ngenxa yabahleli bezinhlelo ze-VBA abakha ama-macros ukuze benze okuzenzakalelayo isimiso sosuku nosuku sokucubungula idatha yasehhovisi. Noma ngubani obone ukuthi i-macro emigqeni eyi-10 yekhodi ithumela kanjani amafayela kumakhasimende angama-200 ngesigamu somzuzu, esikhundleni samahora amathathu omsebenzi oyisiwula, uzongiqonda 🙂

Futhi nokuningi. 

Zonke lezi zinhlelo ezingenhla ziyisinqumo sami siqu kanye nesincomo somuntu siqu esisekelwe kokuhlangenwe nakho komuntu siqu. Akekho noyedwa kubabhali owangicela ukukhangisa futhi akazange akukhokhele (futhi ngeke ngikuthathe, ngomgomo). Uma unokuthile ongakwengeza ohlwini olungenhla - wamukelekile kumazwana, isintu esibongayo ngeke sihlale esikweletini.