Iphrojekthi ye-Excel i-Visual Basic for Applications (VBA) iwulimi lokuhlela olusetshenziswa ngaphakathi kwe-Excel ukwakha izinhlelo ezilula. Ngokuvamile isetshenziselwa ukushintsha imisebenzi eyinkimbinkimbi noma edla isikhathi ibe yizinqubo ezizenzakalelayo, ezonga isikhathi, bese ithuthukisa ikhwalithi yenqubo yokubika. Lawa maphrojekthi e-VBA, nokho, kwesinye isikhathi angavikelwa ngephasiwedi, ukuvikela ubumfihlo bakho noma ukuvikela noma yikuphi ukwephulwa kweskripthi sokuqala esisebenzayo. Ngenxa yalokho, ngezinye izikhathi kungase kube nzima ukukhumbula lawa magama ayimfihlo, noma ngenxa yokuthi abasebenzisi bakhohlwe noma balahlekelwe igama-mfihlo noma ngenxa yezizathu ezihlukahlukene. Ngakho-ke, lesi sihloko sizogqamisa izindlela ezahlukahlukene ezilula ezingasetshenziswa ukususa iphasiwedi kuphrojekthi ye-Excel VBA.
Kunezinhlobo ezimbili zamacala ongahlangabezana nazo lapho uzama ukususa amagama ayimfihlo kumaphrojekthi we-Excel VBA. Sizokhuluma ngazo zombili igxathu negxathu.
Ingxenye 1: Khipha Iphasiwedi Yephrojekthi ye-Excel VBA Ngaphandle Kokwazi Iphasiwedi
Ukuze wenze lokhu, ungasebenzisa izindlela eziningana, ezintathu zazo yilezi ezilandelayo:
Khipha Iphasiwedi Yephrojekthi ye-Excel VBA ngokuchofoza okukodwa kumafayela e-XLS/XLSM
Kunezinhlelo eziningi emakethe ezingakusiza ukuthi ususe amaphasiwedi kuphrojekthi ye-Excel VBA. Isibonelo esihle yilesi I-Passer ye-Excel , okuyisixazululo esilula nesisebenzayo sokususa ngokushesha zonke izivikelo zokuhlela nokufometha ezakhelwe ngaphakathi kweshidi/incwadi yokusebenzela ngekhodi ye-VBA.
Ezinye izici eziyinhloko ze-Passer ye-Excel yilezi:
- Iphasiwedi yephrojekthi ye-VBA encwadini yakho yokusebenzela ye-Excel ingasuswa ngokuchofoza okulula .
- Isiqinisekiso a 100% izinga lempumelelo .
- Ithimba lePhasi liyabakhathalela ukuphepha kwe yabo idatha . Ngeke kube khona ukulahleka kwedatha noma ukuvuza phakathi/ngemuva kwenqubo yokususa.
- Uhlelo lune-a ukuhambisana okubanzi . Isekela i-.xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm namanye amafayela adalwe yi-Microsoft Excel.
Ukukhombisa ukuthi kulula kangakanani ukusebenzisa i-Passer ye-Excel, sikulungiselele umhlahlandlela onemininingwane. Okokuqala, kufanele ulande uhlelo futhi ulufake kukhompyutha yakho.
Isinyathelo 1. Uma usufakiwe, kufanele ukhethe inketho ethi "Susa imikhawulo".
Isinyathelo sesi-2. Sebenzisa inkinobho ethi "Khetha ifayela" ukuze ulayishe ifayela le-Excel elivikelwe ngephasiwedi. Lapho ifayela selingeziwe kusoftware, mane uchofoze kunketho ethi “Susa” ukuze ususe ukuvikelwa kwephasiwedi eshidini lakho le-Excel.
Isinyathelo 3. Phakathi nemizuzwana, igama-mfihlo lephrojekthi ye-VBA lizosuswa encwadini yakho yokusebenzela ye-Excel.
I-Passer ye-Excel Kuwuhlelo olunamandla noluthembekile. Ithole ukubuyekezwa okuhle okuvela kubasebenzisi. Ungangabazi ukuyisebenzisa.
Susa Iphasiwedi ye-Excel VBA Project Online
Enye indlela yokususa iphasiwedi yephrojekthi ye-VBA kumadokhumenti akho e-Excel ukusebenzisa isevisi eku-inthanethi etholakala kuwebhu. Isibonelo esihle salolu hlobo lwethuluzi eliku-inthanethi yi-Office VBA Password Remover. Leli thuluzi eliku-inthanethi likusiza ukuthi ukhiphe ukuvikela kwakho, kodwa lidinga izinyathelo eziningi. Inqubo yilena elandelayo:
Isinyathelo 1: Chofoza okuthi “Vula Ifayela” ukuze ulayishe ifayela lakho le-Excel elivikelwe ngephasiwedi yephrojekthi ye-VBA.
Isinyathelo sesi-2: Chofoza okuthi “Decrypt VBA” ukuze uqinisekise ukulandwa kwedokhumenti entsha.
Isinyathelo sesi-3: Uma isilandiwe, vula idokhumenti. Izokukhumbuza ukuthi iphrojekthi iqukethe ukhiye ongavumelekile. Chofoza u-"Yebo" ukuze uqhubeke.
Isinyathelo sesi-4: Cindezela okuthi ALT+F11 ukuze uvule iphrojekthi ye-VBA. Ngaphakathi kwewindi elikhulu, akufanele ukhulise iphrojekthi. Okulandelayo, iya kokuthi Amathuluzi> I-VBA Project Properties.
Isinyathelo sesi-5: Iya kuthebhu ethi Ukuvikela, setha iphasiwedi entsha oyikhethile bese ushiya ibhokisi lokuhlola likhethiwe.
Isinyathelo sesi-6: Londoloza idokhumenti bese uvala iphrojekthi ye-VBA.
Isinyathelo sesi-7: Vula incwadi yakho yokusebenza ye-Excel futhi bese uphinda isinyathelo sesi-4.
Isinyathelo sesi-8: Kulokhu udinga ukusula ibhokisi lokuhlola nezinkambu zephasiwedi kuthebhu ethi "Ukuvikela".
Isinyathelo 9: Londoloza idokhumenti futhi. Iphasiwedi isusiwe.
Ububi bale ndlela:
- Ukulayisha ifayela lakho le-Excel kuzothatha isikhathi. Futhi, ayikho ibha yokucubungula, ngakho awukwazi ukubona ukuthi ifayela lakho lilayishiwe noma cha.
- Ukulayisha ifayela lakho le-Excel kuwebhusayithi yabo akuphephile kudatha yakho, ikakhulukazi uma idatha yakho ibucayi.
Susa Iphasiwedi ku-Excel VBA Project usebenzisa i-HEX Editor
Isihleli se-hex singaba ithuluzi eliwusizo uma ufuna ukususa mathupha amagama ayimfihlo kuphrojekthi yakho ye-Excel VBA. Kunezindlela ezimbili ezihlukene ezidingekayo ukuze ususe amaphasiwedi asekelwe kusandiso sohlobo lwefayela le-Excel. Ngaphambi kokuqala inqubo eyenziwa ngesandla, khumbula njalo ukwenza isipele samafayela e-Excel osebenza nawo.
Uma uhlobo lwefayela kuyi-XLS:
Isinyathelo 1: Vula ifayela le-.xls elivikelwe ngephasiwedi ngesihleli se-hex bese ubheka iyunithi yezinhlamvu ethi “DPB.”
Isinyathelo sesi-2: Faka esikhundleni i-“DPB” ngokuthi “DPX”.
Isinyathelo sesi-3: Londoloza ifayela bese uphuma kusihleli.
Isinyathelo sesi-4: Okulandelayo, vula ifayela nge-Microsoft Excel. Kuzovela izaziso zamaphutha amaningi, okujwayelekile. Qiniseka ukuthi uchofoza kuzo.
Isinyathelo sesi-5: Manje cindezela u-ALT+F11 ukuze uvule iwindi lephrojekthi ye-VBA bese uchofoza kuzakhiwo ze-VBAProject kumenyu Yamathuluzi.
Isinyathelo sesi-6: Kuthebhu ethi Ukuvikela, shintsha igama-mfihlo liye kokuthile okulula nokukhumbuleka kalula.
Isinyathelo sesi-7: Gcina incwadi yokusebenzela bese uphuma efasiteleni.
Isinyathelo sesi-8: Phinda uvule ibhuku lokusebenzela le-Excel futhi ufinyelele iwindi lephrojekthi ye-VBA ngokucindezela u-ALT+F11 bese ufaka igama-mfihlo osanda kulishintsha. Phinda isinyathelo sesi-6, kodwa kulokhu ungakwazi ukususa iphasiwedi.
Isinyathelo 9: Londoloza incwadi yokusebenzela futhi manje usunefayela le-Excel elingenayo igama-mfihlo.
Uma uhlobo lwefayela kuyi-XLSM:
Kuzandiso ze-.xlsm, isinyathelo esengeziwe siyadingeka ekuqaleni. Ngezansi sikunikeza umhlahlandlela wesinyathelo ngesinyathelo.
Isinyathelo 1: Shintsha isandiso sefayela lakho le-.xlsm libe yi-.zip. Bese uyivula nge-7Zip noma iWinZip.
Isinyathelo sesi-2: Thola futhi ukopishe ifayela elithi “xl/vbaProject.bas” noma elithi “xl/vbaProject.bin” efayeleni le-zip. Qiniseka ukuthi ifolda ye-zip isavuliwe.
Isinyathelo sesi-3: Chofoza futhi uvule ifayela elithi “xl/vbaProject.bas” noma elithi “xl/vbaProject.bin” usebenzisa umhleli we-hex.
Isinyathelo sesi-4: Thola iyunithi yezinhlamvu ethi “DPB” bese uyibuyisela esikhundleni ngokuthi “DPX”.
Isinyathelo sesi-5: Londoloza ifayela, bese ulikopishela emuva kufolda ye-Zip (ungahudula bese uphonsa ifayela kufolda).
Isinyathelo sesi-6: Manje, zip wonke amafayela kufolda uwafake kufayela le-Zip elisha. Okulandelayo, shintsha isandiso sefayela sibe yi-.xlsm.
Isinyathelo sesi-7: Okulandelayo, vula ifayela le-.xlsm. Izaziso zamaphutha ezahlukahlukene zizovela. Chofoza u-"Yebo" ukuze uqhubeke.
Isinyathelo sesi-8: Cindezela okuthi ALT+F11 ukuze uvule iphrojekthi ye-VBA bese uchofoza Izakhiwo ze-VBAProject kumenyu yamathuluzi.
Isinyathelo 9: Vula ithebhu ethi Ukuvikela, susa ukumaka okuthi “Khiya iphrojekthi ukuze ubuke” bese ucindezela okuthi KULUNGILE.
Isinyathelo 10: Londoloza ifayela le-.xlsm bese uvala iwindi
Ububi bale ndlela:
- Baningi abahleli be-hex kuwebhusayithi. Ukukhetha okuhle kuwumsebenzi onzima uma ungenalo ulwazi lobuchwepheshe.
- Abanye abasebenzisi babike ukuthi abakwazi ukulanda isihleli se-hexadecimal. Ngakho-ke, le ndlela ayihlali iwusizo kuwe.
Ingxenye 2: Khipha Iphasiwedi Yephrojekthi ye-Excel VBA enephasiwedi Eyaziwayo
Leli cala lilula ukulisebenzisa futhi liyafana nengxoxo yethu yangaphambilini. Ukuze kube lula ukuqonda, inqubo ichazwe ngezansi:
Isinyathelo 1: Vula ibhuku lakho lokusebenza le-Excel nge-Microsoft Excel. Cindezela u-Alt+F11 ukuze ufinyelele iphrojekthi ye-VBA.
Isinyathelo sesi-2: Iya kokuthi Amathuluzi> Izakhiwo ze-VBAProject. Faka igama-mfihlo elilungile ebhokisini le-VBAProject Password dialog.
Isinyathelo sesi-3: Iya kuthebhu ethi Ukuvikela, susa ukumaka okuthi “Khiya iphrojekthi ukuze ubuke” futhi ukhubaze iphasiwedi emabhokisini alandelayo.
Isinyathelo sesi-4: Chofoza "KULUNGILE" bese ugcine ukusebenza. Yilokho kuphela.
Isiphetho
Kungaba umsebenzi omubi ukususa amaphasiwedi ephrojekthi ye-VBA kumafayela e-Excel. Kuhlale kunconywa ukusebenzisa isisombululo esiphumelelayo nesisebenziseka kalula lapho usebenza nalezi zinhlobo zamafayela. Lokhu konga isikhathi esiningi futhi kulula kakhulu. Zama manje I-Passer ye-Excel futhi uzomangala kakhulu.
