Ulisusa njani igama lokugqithisa kwiProjekthi yeVBA ye-Excel [Iindlela ezi-4]

Ndifuna ukwazi indlela yokususa igama eliyimfihlo kwiprojekthi yeVBA kwi-Excel. Ngubani onokundinceda?

Ngaphambi kokuba ujonge iindlela zokususa iphasiwedi ye-VBA kwi-Excel, kufuneka uqonde intsingiselo ye-VBA. I-VBA sisishunqulelo seVisual Basic for Applications. Isetyenziswa zizicelo ezahlukeneyo zeMS, ngakumbi iMS Excel, ukongeza iifitsha ezithile kunye nokunceda ekwenzeni imisebenzi yesiqhelo. Ngenxa yobume babo kunye nesidingo sokhuseleko lwefayile, uninzi lwabasebenzisi bafihla iiprojekthi ze-VBA ezinamagama ayimfihlo. Nangona kunjalo, abantu abafezekanga kwaye i-VBA passwords inokulibaleka. Intsingiselo ecacileyo kukuba awukwazi ukufikelela okanye uhlele iikhowudi zakho ze-Excel VBA. Ukubetha esi siphithiphithi, udinga indlela yokuqhekeza i-password ye-Excel VBA. Ngethamsanqa, zininzi iindlela zokufezekisa lo msebenzi. Kweli nqaku, uya kufumana isikhokelo eneenkcukacha phezulu 4 iindlela ukwambula Excel VBA passwords.

Icandelo 1: Uyisusa njani iphasiwedi yeProjekthi ye-VBA kwi-Excel Ngaphandle kweeNkqubo

Ukuvula iprojekthi ye-VBA kwi-Excel inokwenziwa ngoncedo lwe-software ye-VBA ye-decryption ezenzekelayo okanye ngeendlela zezandla. Ukujonga indlela yokuqhekeza i-Excel VBA password ngesandla, kukho iindlela ezininzi ezilungileyo ezinokwenza umsebenzi wenziwe. Unokukhetha kolu khetho kwaye uzame ngefayile yakho ekhuselweyo ye-Excel. Ekugqibeleni, enye yezi ndlela inokuba ngcono, kuxhomekeke kubume boxwebhu lwakho olukhuselweyo kunye nesidingo esikhoyo. Ngaphambi kokuba usebenzise ezi ndlela zezandla, kufuneka ugcine iifayile zakho ze-Excel.

Indlela 1. Guqula ulwandiso lwefayile ukuvula imodyuli ye-Excel VBA

Le ndlela ibandakanya ukutshintsha ulwandiso lwefayile ye-.xlsm kwenye ifomathi kwaye emva koko ibuyele kwi-.xlsm ifomathi emva koko. Nangona inkqubo inde, ungayilandela ngononophelo ukususa igama lakho lokugqitha le-Excel VBA ekugqibeleni. La manyathelo alandelayo abonisa ukuba ungaliqhekeza njani igama lokugqitha leprojekthi ye-VBA ye-Excel ngokutshintsha nje ulwandiso lwefayile.

Inyathelo loku-1 : Fumana ifayile ekujoliswe kuyo .xlsm kwaye utshintshe i.

Inyathelo lesi-2 : Ngoku vula le fayile ngayo nayiphi na inkqubo yeArchiver onayo. Ungasebenzisa WinRAR okanye 7-Zip. Ukuba wenza oku, kuya kufuneka ukwazi ukubona oku kulandelayo kuluhlu lwefayile yakho.

Inyathelo lesi-3 : Hamba uye kwi-directory ye-XL ukhetho kwaye ukhuphe ifayile ebhalwe "VBAProject.bin".

Inyathelo lesi-4 : Vula ifayile ye-VBAProject.bin ngokusebenzisa nawuphi na umhleli we-hex kwaye ukhangele okubhaliweyo "DPB=" ngaphakathi kwefayile kumhleli we-hex.

Inyathelo lesi-5 : Wakuba uwufumene lo mbhalo, wucime ngokulula kwaye ubeke “DPX="” endaweni yawo. Ngoku gcina kwaye uvale ifayile yakho kumhleli we-hex. Ibhala ngaphezulu kweVBAProject.bin endala kunye ne-hex-edited.bin entsha ye-VBAProject.bin.

Inyathelo lesi-6 : Buyisela ulwandiso lwefayile ku .xlsm kwaye emva koko uyivule kwi-Excel. Kwifestile ye-pop-up yesilumkiso, khetha "Ewe" kwaye ungazihoyi ezinye iinketho.

Inyathelo lesi-7 : Qhuba umhleli weVBA kwaye ukhethe "Kulungile" ukuba ibhokisi yencoko yababini ibonakala.

Inyathelo lesi-8 : Cofa ekunene igama leprojekthi yakho yeVBA kwaye emva koko ukhethe iipropathi. Khetha ithebhu ethi "Ukhuseleko" kwaye ucime amagama agqithisiweyo akhoyo. Kwakhona, khubaza i-"Tshixa iProjekthi yokuJonga" kwaye uyivule kwakhona. Faka igama lokugqitha elifanelekileyo kwaye uqinisekise. Cofa "Kulungile" ukwenza utshintsho.

Indlela yesi-2. Susa i-Excel VBA Password yeProjekthi ngeHex Editor

Umhleli we-Hex ikunika iqonga elihle lokuhlela iimveliso ze-hex kwaye ekugqibeleni uqhekeze i-password ye-Excel VBA. Ngale ndlela, uya kwenza ifayile ye-xls ye-dummy, usete igama lokugqitha, kwaye uyisebenzise ukufikelela kwi-Excel ekhuselweyo.

Inyathelo loku-1 : Sebenzisa umhleli weHex ukwenza ifayile entsha ye-Excel (xls). Ifayile nje elula inokuyenza.

Inyathelo lesi-2 : Yenza igama eligqithisiweyo lale fayile kwicandelo leVBA. Ungacinezela Alt+F11 ukufikelela kolu khetho.

Inyathelo lesi-3 : Emva kokuba wenze igama eliyimfihlo ekulula ukulikhumbula, gcina le fayile intsha kwaye uphume.

Inyathelo lesi-4 : Vula le fayile yenziwe ngokutsha, kodwa ngeli xesha, yivule ngomhleli we-hex. Nje ukuba ivulwe, khangela kwaye ukope imigca, eqala ngala maqhosha alandelayo: CMG=, DPB= kunye neGC=.

Inyathelo lesi-5 : Ngoku vula ifayile ye-Excel apho ufuna ukwaphula igama lokugqitha ngomhleli weHex. Ncamathelisa imibhalo ekhutshelweyo kwiindawo ezifanelekileyo kwaye ugcine utshintsho. Phuma kwifayile.

Inyathelo lesi-6 : Ngesiqhelo vula ifayile ye-Excel kwaye usebenzise igama eligqithisiweyo elifanayo olenzileyo kwifayile ye-dummy xls ukujonga ikhowudi yeVBA.

Indlela yesi-3. Susa igama lokugqitha kwiprojekthi ye-Excel VBA nge-Visual Basic Editor

Ngokungafaniyo nomhleli we-Hex, Umhleli oSiseko wokuVisual uvumela abasebenzisi ukuhlela iikhowudi zabalinganiswa endaweni yeehexadecimal. Inkqubo ayinde kangako. Nangona kunjalo, kufuneka ulumke kuba iikhowudi zifuna ingqalelo ukuphepha iimpazamo. La manyathelo alandelayo abonisa ngokucacileyo ukuba ungaliqhekeza njani igama lokugqitha le-Excel Macro ngoHlelo oluSiseko lweVisual.

Inyathelo loku-1 : Vula ngokwakho incwadi yokusebenza efanelekileyo enephepha elikhuselweyo le-Excel.

Inyathelo lesi-2 : Ngoku vula i-Visual Basic Editor usebenzisa i-Alt+F11 umyalelo. Yiya kwi Modyuli yokulungisela kwaye emva koko uncamathisele ikhowudi elandelayo kwikhowudi yefestile ekhoyo ekunene.

Inyathelo lesi-3 : Phuma kwifestile yoMhleli weVBA kwaye uqhubeke nephepha lomsebenzi elikhuselweyo.

Inyathelo lesi-4 : Yiya kwiZixhobo> Iimakhro> Iimakhro. Kuluhlu oluvelayo, nqakraza kabini kwinketho ethi "PasswordBreaker". Kuya kufuneka ngoku ukwazi ukufikelela kwifayile yakho ye-Excel ekhuselwe ngegama eliyimfihlo.

Icandelo 2: Ukulinganiselwa okwenziwa ngesandla xa uvula iprojekthi yeVBA kwi-Excel

Nangona iindlela manual ziluncedo ngokukrazula Excel VBA passwords, akukho ndawo kufutshane igqibelele. Ezi ndlela zithwaxwa ziingxaki ezininzi ezenza ukuba zingasebenzi kakuhle xa kufikwa kwiifayile ezibalulekileyo nezintsonkothileyo ze-Excel. Oku kulandelayo yeminye imida eqhelekileyo yeendlela zezandla.

• Ifuna ulwazi lobugcisa : Njengoko ubonile, uninzi lwezi zikhetho zingentla zibandakanya ikhowudi eninzi. Ke ukuba unolwazi oluncinci lobugcisa, uya kuba nexesha elinzima ngolu khetho lwezandla.
• Kutya ixesha elininzi : Iindlela ezininzi zezandla zibandakanya iinkqubo ezinde. Inyani yokuba ikwabandakanya iikhowudi kunye nokuhamba kuwo wonke amaqonga amaninzi iyenza idinwe ngakumbi kwaye ke abasebenzisi baya kuyifumana icotha kwaye iyadika.
• Izinga lempumelelo : Yintoni ebalulekileyo, ekugqibeleni, kukuba singakwazi ukukrazula i-password ye-Excel VBA okanye hayi. Ngelishwa, ezi zikhetho zezandla zibhala awona mazinga asezantsi empumelelo. Ngoko ke, akucebisi ukuba uchithe ixesha elininzi kunye namandla kwaye ungafumani umphumo oyifunayo.

Oko kwathiwa, ukuba zonke iinketho ziyasilela okanye udinwe ziintsilelo zabo, kamva zama ukusebenzisa izicelo ezikhethekileyo ezifana nePassers ye-Excel ukukrazula i-Excel VBA password ngokuzenzekelayo.

Inxalenye 3: Indlela Crack Excel VBA Password ngokuzenzekelayo

Ipasile le-Excel sisixhobo esinamandla ngokumangalisayo sokuvula igama lokugqitha kwiifayile ze-Excel. Inkqubo iqinisekisa i-100% izinga lempumelelo ukukrazula i-password yeprojekthi ye-Excel VBA. Ngesantya esiphezulu esikhawulezayo sokuguqulela kunye nokusebenziseka ngokulula, akukho sizathu sakuthandabuza isakhono sePassper ye-Excel. Kwakhona kubalulekile ukuqaphela ukuba iPasspers ye-Excel inokusetyenziselwa ukuqhekeza igama lokuvula uxwebhu kwiifayile ze-Excel.

Iimpawu eziphambili zePasipoti ye-Excel:

• Zonke izithintelo zokuhlela kunye nokufomatha kwiprojekthi yakho ye-VBA, kwiphepha lomsebenzi, okanye incwadi yomsebenzi inokuqondwa ngoko nangoko.
• NgePasser ye-Excel, ukucofa ngokulula kuya kukuvumela ukuba ulahle ukhuseleko lokugqitha kwiprojekthi yakho yeVBA.
• Idatha yakho ayiyi kuchaphazeleka okanye yonakaliswe emva kokusebenzisa inkqubo.
• Inkqubo inokuhambelana okubanzi kakhulu. Zonke iindidi zeefayile ze-Excel eziquka .xlsm, .xlsb, .xltx, .xltm ziyahambelana nayo.

I-Passer ye-Excel isebenze izigidi zabasebenzisi kwihlabathi liphela. Kwaye ifumene uphononongo oluhle kubasebenzisi bayo. Ungalibazisi ukuyizama ngoku.

Yizame simahla

Uyisusa njani igama lokugqitha le-VBA kwi-Excel ngePassper ye-Excel

Inyathelo loku-1: Qalisa iPass ye-Excel kwiPC yakho kwaye ucofe kwindawo ethi "Susa izithintelo".

Inyathelo lesi-2: Kwifestile entsha, nqakraza iqhosha elithi "Khetha iFayile" kwaye ulandele imiyalelo ekwisikrini ukuze ulayishe ifayile ye-Excel VBA ekhuselweyo kwi-interface yeprogram.

Inyathelo lesi-3: Xa ifayile ye-password ekhuselweyo ilayishiwe, cofa inketho ethi "Cima" ukususa igama lokugqitha leprojekthi yeVBA kwifayile yakho ye-Excel.

Inkqubo izakususa ngokuzenzekelayo izithintelo kwimizuzwana. Xa igqityiwe, kuya kufuneka ubone isaziso sempumelelo emazantsi esikrini.

Ukuqukumbela

Esi sikhokelo siye sachaza ngokucacileyo ezinye zeendlela ezibambekayo zokuqhekeza iipassword ze-Excel VBA. Nangona kunjalo, ezinye iifom ziphezulu kunabanye ngenxa yokukwazi kwabo ukuphatha iiphasiwedi eziyinkimbinkimbi ze-VBA, ukusetyenziswa lula, kunye namazinga okuphumelela ashicilelwe. Ukususela kwisixa esikhulu solwazi olunikezelwe ngasentla, akukho mntu unokuphikisa Ipasile le-Excel njengesisombululo sokwenyani sokuqhekeka iprojekthi ye-Excel VBA password. Zonke iiparameters zokulinganisa zibeka phambili kwiinketho zezandla. Khetha iPasi ye-Excel kwaye usombulule iingxaki zakho zephasiwedi ye-VBA ngonaphakade.

Yizame simahla