Ungalisusa Kanjani Iphasiwedi Kuphrojekthi Ye-Excel VBA [Izindlela Ezi-4]

Ngifuna ukwazi ukuthi ungayisusa kanjani iphasiwedi kuphrojekthi ye-VBA ku-Excel. Ngubani ongangisiza?

Ngaphambi kokufuna izindlela zokususa iphasiwedi ye-VBA ku-Excel, kufanele uqonde incazelo ye-VBA. I-VBA isifinyezo se-Visual Basic for Applications. Isetshenziswa izinhlelo zokusebenza ezahlukahlukene ze-MS, ikakhulukazi i-MS Excel, ukwengeza izici ezithile kanye nokusiza ekuzenzeleni imisebenzi yenjwayelo. Ngenxa yemvelo yabo nesidingo sokuphepha kwamafayela, abasebenzisi abaningi babhala ngemfihlo amaphrojekthi e-VBA ngamaphasiwedi. Kodwa-ke, abantu abaphelele futhi amaphasiwedi e-VBA angakhohlwa. Okushiwo okusobala ukuthi awukwazi ukufinyelela noma ukuhlela amakhodi akho e-Excel VBA. Ukuze unqobe lesi siphithiphithi, udinga indlela yokuqhekeza iphasiwedi ye-Excel VBA. Ngenhlanhla, ziningi izindlela zokufeza lo msebenzi. Kulesi sihloko, uzothola umhlahlandlela onemininingwane ezindleleni ezi-4 eziphezulu zokuqhekeka amaphasiwedi e-Excel VBA.

Ingxenye 1: Indlela Yokukhipha Iphasiwedi Yephrojekthi ye-VBA ku-Excel Ngaphandle Kwezinhlelo

Ukuvula iphrojekthi ye-VBA ku-Excel kungenziwa ngosizo lwe-software ye-VBA yokubhala ngokuzenzakalelayo noma ngezindlela ezenziwa ngesandla. Ukubheka indlela yokuqhekeza iphasiwedi ye-Excel VBA ngesandla, kunezindlela ezimbalwa ezinhle zokwenza umsebenzi wenziwe. Ungakhetha kulezi zinketho bese uzama ngefayela lakho le-Excel elivikelwe. Ekugcineni, enye yalezi zinketho ingase ibe ngcono, kuye ngohlobo lwedokhumenti yakho evikelwe kanye nesidingo esiseduze. Ngaphambi kokusebenzisa lezi zindlela ezenziwa ngesandla, kufanele wenze isipele amafayela akho e-Excel.

Indlela 1. Shintsha isandiso sefayela ukuze uvule imojuli ye-Excel VBA

Le ndlela ihlanganisa ukushintsha isandiso sefayela le-.xlsm siye kwenye ifomethi bese sibuyela kufomethi ye-.xlsm ngemva kwalokho. Nakuba inqubo iyinde, ungayilandela ngokucophelela ukuze ususe iphasiwedi yakho ye-Excel VBA ekugcineni. Izinyathelo ezilandelayo zibonisa ukuthi ungaliqhekeza kanjani iphasiwedi yephrojekthi ye-Excel VBA ngokushintsha nje isandiso sefayela.

Isinyathelo 1 : Thola ifayela le-.xlsm eliqondiwe bese ushintsha isandiso sefayela le-.xlsm sibe zip.

Isinyathelo sesi-2 : Manje vula leli fayela nganoma yiziphi izinhlelo ze-Archiver onazo. Ungasebenzisa i-WinRAR noma i-7-Zip. Uma wenza lokhu, kufanele ukwazi ukubona isakhiwo esilandelayo senkomba yefayela lakho.

Isinyathelo sesi-3 : Zulazulela kuhlu lwemibhalo ye-XL bese ukhipha ifayela elibhalwe ukuthi “VBAProject.bin”.

Isinyathelo sesi-4 : Vula ifayela le-VBAProject.bin ngokusebenzisa noma yimuphi umhleli we-hex futhi uhlole umbhalo othi “DPB=” ngaphakathi kwefayela kumhleli we-hex.

Isinyathelo sesi-5 : Uma usuwutholile lo mbhalo, vele uwususe bese ufaka okuthi “DPX="” esikhundleni salokho. Manje gcina futhi uvale ifayela lakho kusihleli se-hex. Ibhala phezu kwe-VBAProject.bin endala nge-VBAProject.bin entsha ehlelwe nge-hex.

Isinyathelo sesi-6 : Buyisela isandiso sefayela ku-.xlsm bese usivula ku-Excel. Ewindini le-pop-up yesixwayiso, khetha okuthi “Yebo” bese ungaziba ezinye izinketho.

Isinyathelo sesi-7 : Qalisa umhleli we-VBA bese ukhetha "KULUNGILE" uma ibhokisi lengxoxo livela.

Isinyathelo sesi-8 : Chofoza kwesokudla igama lephrojekthi yakho ye-VBA bese ukhetha izakhiwo. Khetha ithebhu "Ukuvikela" bese ususa amaphasiwedi akhona. Futhi, khubaza ibhokisi lokuhlola elithi “Khiya Iphrojekthi Yokubuka” bese uyivula futhi. Faka iphasiwedi efanelekile bese uyiqinisekisa. Chofoza "KULUNGILE" ukuze wenze izinguquko.

Indlela 2. Khipha Iphasiwedi Yephrojekthi ye-Excel VBA nge-Hex Editor

I-Hex Editor ikunikeza inkundla enhle yokuhlela imikhiqizo ye-hex futhi ekugcineni uqhekeze iphasiwedi ye-Excel VBA. Ngale ndlela, uzodala ifayela le-dummy xls, usethe iphasiwedi, futhi uyisebenzisele ukufinyelela ku-Excel evikelwe.

Isinyathelo 1 : Sebenzisa umhleli we-Hex ukuze udale ifayela elisha le-Excel (xls). Ifayela nje elilula lingakwenza.

Isinyathelo sesi-2 : Dala iphasiwedi yaleli fayela esigabeni se-VBA. Ungacindezela u-Alt+F11 ukuze ufinyelele le nketho.

Isinyathelo sesi-3 : Ngemva kokuthi udale iphasiwedi okulula ukuyikhumbula, londoloza leli fayela elisha bese uphuma.

Isinyathelo sesi-4 : Vula leli fayela elisanda kwakhiwa, kodwa kulokhu, livule ngomhleli we-hex. Uma isivuliwe, thola futhi ukopishe imigqa, eqala ngokhiye abalandelayo: CMG=, DPB= and GC=.

Isinyathelo sesi-5 : Manje vula ifayela le-Excel ofuna ukuqhekeza ngalo iphasiwedi ngomhleli we-Hex. Namathisela imibhalo ekopishiwe ezinkambini ezifanele bese ulondoloza izinguquko. Phuma kufayela.

Isinyathelo sesi-6 : Ngokuvamile vula ifayela le-Excel futhi usebenzise igama-mfihlo elifanayo naleli olidalile ifayela le-dummy xls ukuze ubuke ikhodi ye-VBA.

Indlela 3. Susa iphasiwedi kuphrojekthi ye-Excel VBA nge-Visual Basic Editor

Ngokungafani nomhleli we-Hex, i-Visual Basic Editor ivumela abasebenzisi ukuthi bahlele amakhodi ezinhlamvu esikhundleni sama-hexadecimal. Inqubo ayinde kangako. Kodwa-ke, kufanele uqaphele ngoba amakhodi adinga ukunakwa ukuze ugweme amaphutha. Izinyathelo ezilandelayo zibonisa ngokucacile ukuthi ungaliqhekeza kanjani iphasiwedi ye-Excel Macro nge-Visual Basic Editor.

Isinyathelo 1 : Vula ngokuzenzela incwadi yokusebenza efanele equkethe ishidi le-Excel elivikelwe.

Isinyathelo sesi-2 : Manje vula i-Visual Basic Editor usebenzisa umyalo we-Alt+F11. Iya kokuthi Shumeka Imojula bese unamathisela ikhodi elandelayo efasiteleni lekhodi elitholakala kwesokudla.

Isinyathelo sesi-3 : Phuma ewindini Lomhleli we-VBA futhi uqhubeke neshidi lomsebenzi elivikelwe.

Isinyathelo sesi-4 : Iya kokuthi Amathuluzi > Imakhro > Amamakhro. Ohlwini oluvelayo, chofoza kabili kunketho ethi “PasswordBreaker”. Manje kufanele ukwazi ukufinyelela ifayela le-Excel elivikelwe ngephasiwedi.

Ingxenye 2: Ukulinganiselwa okwenziwa ngesandla lapho uvula iphrojekthi ye-VBA ku-Excel

Nakuba izindlela zemanuwali ziwusizo ekuqhekezeni amaphasiwedi e-Excel VBA, akukho ndawo aseduze nokuphelela. Lezi zindlela zikhungethwe izinkinga eziningi ezizenza zingalingani kahle uma kukhulunywa ngamafayela e-Excel abalulekile futhi ayinkimbinkimbi. Okulandelayo eminye yemikhawulo evamile yezindlela ezenziwa ngesandla.

• Idinga ulwazi lobuchwepheshe : Njengoba ubonile, eziningi zezinketho ezingenhla zihlanganisa amakhodi amaningi. Ngakho-ke uma unolwazi oluncane lwezobuchwepheshe, uzoba nesikhathi esinzima ngalezi zinketho zamanuwali.
• Kudla isikhathi esiningi : Izindlela eziningi ezenziwa ngesandla zibandakanya izinqubo ezinde. Iqiniso lokuthi iphinde ifake amakhodi nokunyakaza ezinkundleni eziningi iyenza ikhathale ngakho-ke abasebenzisi bazoyithola ihamba kancane futhi iyisicefe.
• Izinga lempumelelo : Okubalulekile, ekugcineni, ukuthi singakwazi ukuqhekeza iphasiwedi ye-Excel VBA noma cha. Ngeshwa, lezi zinketho zamanuwali ziqopha amanani empumelelo aphansi kakhulu. Ngakho-ke, akufanelekile ukuchitha isikhathi esiningi namandla bese ungawutholi umphumela owudingayo.

Sesikushilo lokho, uma zonke izinketho zehluleka noma ukhathala ngenxa yokushiyeka kwazo, kamuva zama ukusebenzisa izinhlelo ezikhethekile ezifana ne-Passper ye-Excel ukuze uvule iphasiwedi ye-Excel VBA ngokuzenzakalelayo.

Ingxenye 3: Indlela Crack Excel VBA Iphasiwedi Ngokuzenzakalelayo

I-Passer ye-Excel iyithuluzi elinamandla ngendlela emangalisayo lokuvula iphasiwedi yamafayela e-Excel. Uhlelo luqinisekisa izinga lempumelelo elingu-100% ukuze kuqhamuke iphasiwedi yephrojekthi ye-Excel VBA. Ngesivinini esisheshayo sokuqanjwa nokusebenziseka kalula, asikho isizathu sokungabaza ikhono le-Passer le-Excel. Kubalulekile futhi ukuqaphela ukuthi i-Passer ye-Excel ingasetshenziswa ukuqhekeza iphasiwedi yokuvula idokhumenti kumafayela e-Excel.

Izici ezibalulekile ze-Passer ye-Excel:

• Yonke imikhawulo yokuhlela nokufometha kuphrojekthi yakho ye-VBA, ishidi lokusebenza, noma incwadi yokusebenza ingacaciswa ngokushesha.
• Nge-Passer ye-Excel, ukuchofoza okulula kuzokuvumela ukuthi ukhiphe ukuvikelwa kwephasiwedi kuphrojekthi yakho ye-VBA.
• Idatha yakho ngeke ithinteke noma yonakaliswe ngemuva kokusebenzisa uhlelo.
• Uhlelo lunokuhambisana okubanzi kakhulu. Zonke izinhlobo zamafayela e-Excel okuhlanganisa .xlsm, .xlsb, .xltx, .xltm ziyahambisana nayo.

I-Passer ye-Excel isebenzele izigidi zabasebenzisi emhlabeni jikelele. Futhi ithole ukubuyekezwa okuhle kubasebenzisi bayo. Ungangabazi ukuyizama manje.

Yizame mahhala

Ungayisusa kanjani iphasiwedi ye-VBA ku-Excel nge-Passer ye-Excel

Isinyathelo 1: Yethula i-Passer ye-Excel ku-PC yakho bese uchofoza kunketho ethi “Susa Imikhawulo”.

Isinyathelo sesi-2: Ewindini elisha, chofoza inkinobho ethi "Khetha Ifayela" bese ulandela imiyalelo esesikrinini ukuze ulayishe ifayela le-Excel VBA elivikelwe ngephasiwedi kusixhumi esibonakalayo sohlelo.

Isinyathelo sesi-3: Lapho ifayela elivikelwe ngephasiwedi lilayishiwe, cindezela inketho ethi “Susa” ukuze ukhiphe iphasiwedi yephrojekthi ye-VBA kufayela lakho le-Excel.

Uhlelo luzosusa ngokuzenzakalelayo imikhawulo phakathi nemizuzwana. Uma iqeda, kufanele ubone isaziso sempumelelo ezansi kwesikrini.

Isiphetho

Lo mhlahlandlela uye wachaza ngokucacile ezinye zezindlela ezizwakalayo zokuqhekeza amaphasiwedi e-Excel VBA. Kodwa-ke, amanye amafomu aphakeme kakhulu kunamanye ngenxa yekhono lawo lokuphatha amaphasiwedi e-VBA ayinkimbinkimbi, ukusebenziseka kalula, namazinga empumelelo ashicilelwe. Kusukela enanini elikhulu lolwazi olunikezwe ngenhla, akekho ongaphikisa I-Passer ye-Excel njengesixazululo sangempela sokuqhekeka iphasiwedi yephrojekthi ye-Excel VBA. Wonke amapharamitha wokulinganisa akubeka phambili kunezinketho ezenziwa ngesandla. Khetha i-Passer ye-Excel futhi uxazulule izinkinga zakho zephasiwedi ye-VBA unomphela.

Yizame mahhala