Zothandiza pa pulogalamu ya VBA

Ngati mumatchula mawu oti "macros" ndi mpweya woopsa komanso mawu omveka pa syllable yachiwiri, ndipo mawu oti "Visual Basic for Applications" akumveka ngati spell kwa inu, ndiye kuti nkhaniyi si yanu. Mulimonsemo, pakadali pano 🙂

Ngati muli ndi chidziwitso pakupanga ma macros mu VBA ku Excel, ndipo simukukonzekera kuyimitsa, ndiye kusankha zowonjezera ndi mapulogalamu omwe ali pansipa kuyenera kukhala (osachepera) kothandiza kwa inu.

MZ-Tools - "Mpeni wa ku Swiss" kwa wopanga mapulogalamu

Pambuyo kukhazikitsa mu VBE mkonzi mu menyu zida submenu idzawoneka Zida za MZ ndi chida chatsopano kuti mupeze mwachangu ntchito zomwezo:

Amadziwa kuchita zambiri. Zamtengo wapatali kwambiri, mwa lingaliro langa:

• Onjezani zokha "nsomba zopanda kanthu" kuti mupange njira, magwiridwe antchito, zochitika ndi zolakwika ndikutchula mayina olondola malinga ndi dongosolo la Chihangare.
  
• Koperani zowongolera pamitundu yogwiritsa ntchito limodzi ndi ma code awo.
  
• Pangani zikhomo (Zokonda) zamachitidwe ndikusunthira kwa iwo mwachangu mu polojekiti yayikulu.
• Gawani mizere yayitali yamakhodi kukhala angapo ndikusonkhanitsira mmbuyo (kugawa ndi kuphatikiza mizere).
  
• Perekani ziwerengero zatsatanetsatane za polojekiti (chiwerengero cha mizere, njira, zinthu pamafomu, ndi zina zotero)
• Yang'anani pulojekitiyi pazosintha zosagwiritsidwa ntchito ndi njira (Review Source)
• Pangani maziko anu a ma code templates (Ma Code Templates) amilandu wamba ndikuyika mwachangu m'makina atsopano pambuyo pake.
• Pangani zokha chingwe chachitali komanso chowopsa kuti mulumikizane ndi magwero akunja a data kudzera pa ADO.
  
• Gwirizanitsani ma hotkey ku ntchito iliyonse kuchokera pazowonjezera.
  

Chofunikira chodziwika bwino kwa wopanga mapulogalamu amtundu uliwonse. Ngati muli ndi Office yatsopano, onetsetsani kuti mwatsitsa MZ-Tools 3.00.1218 yaposachedwa kwambiri pa Marichi 1, chifukwa. idakonza cholakwika pogwira ntchito ndi Excel 2013.  

Download kugwirizana Zida za MZ

Smart Indentation - kudziwikiratu mu code

Imagwira ntchito imodzi yosavuta koma yofunikira kwambiri - imangolowetsa ma tabo mu code ya VBA, ikuwonetsa momveka bwino malupu okhala ndi zisa, kuwunika momwe zinthu ziliri, ndi zina zambiri.

Ndizosavuta kupatsa izi kunjira yachidule ya kiyibodi yomwe ili mgawoli Zosankha Zolowera ndi kuchita ndi kukhudza kumodzi.

Tsoka ilo, mlembi wa pulogalamuyi adasiya mu 2005 (bwanji, Carl!?) Komabe, pulogalamuyi imagwira ntchito bwino ndi mitundu yatsopano. Chenjezo lokhalo: ngati muli ndi Excel 97, ndiye musanayike Smart Indenter, muyenera kukhazikitsa mtundu waposachedwa wa MZ-Tools, chifukwa. lili ndi laibulale yamphamvu yofunikira pantchito ya Indenter.

Download kugwirizana Smart Inter

Zida za VBE - zosintha zazing'ono m'mitundu

Kuwongolera kuwongolera (mabatani, minda yolowera, zolemba zolemba, etc.) pa fomu yovuta kungakhale kowawa. Kumangirira kokhazikika kugulu la mkonzi kudzera pa menyu Zida - Zosankha - Zambiri - Gwirizanitsani maulamuliro ku Gridi nthawi zina sizimathandiza kwambiri ndipo zimayambanso kuyenda, makamaka ngati mukufuna kusuntha, mwachitsanzo, batani pang'ono chabe. Zowonjezera Zida za VBE zithandizira pankhaniyi, yomwe, ikakhazikitsa, imawonetsa gulu losavuta momwe mungathe kuwongolera kukula ndi malo pa fomu ya chinthu chomwe mwasankha:

Kusintha kwa malo kumathanso kuchitidwa ndi Alt+mivi, ndikusinthiranso mivi ya Shift+Alt+ ndi Ctrl+Alt+mivi.

Komanso, podina kumanja pa chinthu, mutha kuchitchanso nthawi yomweyo ndi code.

Download kugwirizana Zida za VBE

VBA Diff - Kupeza Kusiyana kwa Code

Chida ichi chingakhale chothandiza kwambiri kwa akatswiri opanga mapulogalamu a VBA popanga mapulojekiti akuluakulu ndi ovuta kapena chitukuko chogwirizana. Ntchito yake yayikulu ndikufanizira mapulojekiti awiri ndikuwonetsa kusiyana pakati pawo:

Pali nthawi yaulere ya masiku 30, ndiyeno chowonjezeracho chidzakufunsani kuti mupereke ndalama zokwana mapaundi 39 (pafupifupi ma ruble 3.5 pakusinthana kwapano).

Kunena zowona, zidakhala zothandiza m'moyo wanga nthawi 3-4 zokha pamapulojekiti akulu kwambiri, koma zidandipulumutsa masiku angapo komanso ma cell amitsempha ambiri 🙂 Chabwino, nthawi zonse pamakhala njira ina yaulere: kutumiza kunja code ku fayilo yolemba (dinani kumanja modulo - Tumizani) ndikufanizira pambuyo pake mu Microsoft Word pogwiritsa ntchito lamulo Ndemanga - Fananizani Zolemba, koma mothandizidwa ndi VBA Diff ndi dongosolo la kukula kosavuta.

Download kugwirizana Kusiyana kwa VBA

Moqups ndi Wireframe Sketcher - mawonekedwe a mawonekedwe

Mukapanga zolumikizira zovuta zolumikizirana ndi ogwiritsa ntchito, ndikwabwino kwambiri kupanga pasadakhale mawonekedwe ofananira a mabokosi a zokambirana, mwachitsanzo, kuchita. prototyping. M'malo mwake, zimakhala zophweka kuposa kukonzanso mafomu okonzeka komanso ma code awo pambuyo pake. Ndikukumbukira kamodzi mu imodzi mwama projekiti omwe kasitomala adafunsa kuti apange "menyu", kutanthauza "ma tabu". Theka la tsiku logwira ntchito kukhetsa 🙁

Pali chiwerengero chachikulu cha mapulogalamu olipidwa komanso aulere amitundu yosiyanasiyana yazovuta komanso mphamvu zantchito izi. Ndayesapo mapulogalamu ndi mautumiki otere khumi ndi awiri, ndipo posachedwapa ndimagwiritsa ntchito nthawi zambiri makutu:

Uyu ndi mkonzi wa pa intaneti yemwe:

• Sichifuna kukhazikitsa mapulogalamu osiyana. Inu nthawi zonse kubwera ku ofesi kasitomala ndi lotseguka-show-zolondola analenga mawonekedwe pomwe pa malo.
• Muli zinthu zonse zazikulu zamabokosi a zokambirana (malebulo, mabatani, mindandanda, ndi zina) m'mitundu ya Windows ndi Mac.
• Imakulolani kutumiza mawonekedwe opangidwa mu PNG kapena ma PDF kapena kutumiza ulalo kwa kasitomala kuti muwonere pa intaneti.
  
• Zowona zaulere. Pali malire pa kuchuluka kwa zinthu zojambulidwa, koma sindinathe kuzidutsa. Ngati mulibe malo kapena mukufuna kusunga mapulojekiti akuluakulu angapo nthawi imodzi, mutha kukweza mtundu wamtengo wapatali $99 pachaka.

Kawirikawiri, chifukwa cha ntchito za wopanga ku VBA - kuposa zokwanira, ndikuganiza.

Ngati wina aliyense akufunikira njira yopanda intaneti (mwachitsanzo, kugwira ntchito popanda intaneti m'mphepete mwa nyanja), ndiye ndikupangira Wireframe Sketcher:

Pambuyo pa nthawi yachiwonetsero yaulere kwa masabata a 2, adzakufunsani kuti mugule $99 yomweyo.

Lumikizani makutu

Download kugwirizana Wireframe Sketcher

Invisible Basic - code obfuscator

Tsoka ilo, sizingatheke kutseka chinsinsi cha macros anu ndi mawu achinsinsi mu Microsoft Excel. Komabe, pali gulu lonse la mapulogalamu otchedwa obfuscators (Kuchokera ku Chingerezi. kusokoneza - kusokoneza, kusokoneza), zomwe zimasintha maonekedwe a code ya VBA m'njira yakuti zikhale zovuta kwambiri kuziwerenga ndikuzimvetsa, zomwe ndi:

• mayina amitundu, machitidwe ndi ntchito zimasinthidwa ndi zilembo zazitali zopanda tanthauzo kapena, mosiyana, ndi zilembo zazifupi zosamvetsetseka.
  
• ma indents a ma tabulation amachotsedwa
• amachotsedwa kapena, mosiyana, zoduka mizere zimayikidwa mwachisawawa, etc.

Kunena zoona, sindine wokonda kugwiritsa ntchito njirazi. Makamaka, ndi PLEX, ndinaganiza kuti zingakhale bwino kupatsa ogula mtundu wathunthu wotseguka, womveka komanso wofotokozera ndemanga - izi zikuwoneka kwa ine zolondola. Komabe, olemba mapulogalamu anzanga akhala ndi zochitika mobwerezabwereza pamene pulogalamu yotereyi ingakhale yothandiza kwambiri (wopanga mapulogalamuwo adagwira ntchitoyo, koma kasitomala sanalipira, etc.) Kotero ngati mukuyifuna, dziwani komwe mungaipeze. "Ndife anthu amtendere, koma sitima yathu yankhondo ..." ndi zonsezo.

Download Invisible Basic

Code Cleaner - kuyeretsa ma code

Pogwira ntchito pulojekiti (makamaka ngati ndi yayikulu komanso yayitali), "zinyalala" zimayamba kudziunjikira mu ma code modules ndi mafomu - zidutswa za VBE mkonzi wautumiki zomwe zingayambitse zosayembekezereka komanso zosafunikira. Zothandiza Code Cleaner imayeretsa matope awa m'njira yosavuta koma yodalirika: imatumiza kachidindo kuchokera ku ma module kupita ku mafayilo amawu, kenako ndikubwezeretsanso bwino. Ndikupangira kuti mukamagwira ntchito zazikulu, nthawi ndi nthawi muzichita "kuyeretsa" koteroko.

Download kugwirizana Code Cleaner

Riboni XML Editor

Ngati mukufuna kupanga tabu yanu yokhala ndi mabatani okongola pa riboni ya Excel kuti muyendetse ma macros anu, ndiye kuti simungathe kuchita popanda mawonekedwe a XML file editor. Ndithudi, yabwino kwambiri komanso yamphamvu lero ndi pulogalamu yapakhomo pankhaniyi. Riboni XML Editorwopangidwa ndi Maxim Novikov.

Mapulogalamu odabwitsa kwambiri omwe:

• zikuthandizani kuti muwonjezere mosavuta ma tabu anu, mabatani, mindandanda yotsikira pansi ndi zinthu zina za mawonekedwe a Office pa riboni
• fully supports language
• imathandizira pakusintha powonetsa malingaliro amkati
• zitha kuzindikirika mosavuta ndi maphunziro
  
• kwathunthu kwaulere

Download kugwirizana Riboni XML Editor

PS

Kwa zaka zambiri, Microsoft yanyalanyaza mwatsatanetsatane opanga VBA, powaganizira, mwachiwonekere, kukhala chinenero chotsika kwambiri cha mapulogalamu. Mphekesera zimatsika nthawi ndi nthawi kuti mtundu wotsatira wa Office sudzakhalanso ndi Visual Basic kapena usinthidwa ndi JavaScript. Mitundu yatsopano ya Visual Studio imatuluka pafupipafupi ndi zinthu zatsopano, ndipo mkonzi wa VBE adakakamira mu 1997, osathabe kuyika kachidindo ndi zida wamba.

Zoona zake, anthu masauzande ambiri akupulumutsa maola ndi masiku chifukwa cha opanga mapulogalamu a VBA omwe amapanga macros kuti azitha kusintha machitidwe a tsiku ndi tsiku amaofesi. Aliyense amene wawona momwe macro mu mizere ya 10 amatumizira mafayilo kwa makasitomala a 200 mu theka la miniti, m'malo mwa maola atatu a ntchito yopusa, andimvetsa 🙂

Ndipo kwambiri. 

Mapulogalamu onse omwe ali pamwambawa ndi chisankho changa komanso malingaliro anga malinga ndi zomwe ndakumana nazo. Palibe m'modzi mwa olemba omwe adandifunsa zotsatsa ndipo sanandilipire (ndipo sindingatenge, pamfundo). Ngati muli ndi chinachake choti muwonjezere pamndandanda womwe uli pamwambapa - kulandiridwa ku ndemanga, umunthu woyamikira sudzakhalabe ndi ngongole.