Momwe Mungachotsere Mawu Achinsinsi ku Excel VBA Project [Njira 4]

Ndikufuna kudziwa momwe mungachotsere mawu achinsinsi ku polojekiti ya VBA ku Excel. Ndani angandithandize?

Musanayambe ngakhale kufunafuna njira kuchotsa VBA achinsinsi mu Excel, muyenera kumvetsa tanthauzo la VBA. VBA ndi chidule cha Visual Basic for Applications. Imagwiritsidwa ntchito ndi mapulogalamu osiyanasiyana a MS, makamaka MS Excel, kuwonjezera zinthu zina komanso kuthandiza pakupanga ntchito zanthawi zonse. Chifukwa cha chikhalidwe chawo komanso kufunikira kwa chitetezo cha mafayilo, ogwiritsa ntchito ambiri amabisa mapulojekiti a VBA ndi mapasiwedi. Komabe, anthu si angwiro ndipo VBA mapasiwedi akhoza kuiwalika. Tanthauzo lodziwikiratu ndikuti simungathe kupeza kapena kusintha ma code anu a Excel VBA. Kuti mugonjetse chipwirikiti ichi, muyenera njira yosokoneza mawu achinsinsi a Excel VBA. Mwamwayi, pali njira zambiri zokwaniritsira ntchitoyi. M'nkhaniyi, mudzalandira kalozera mwatsatanetsatane pamwamba 4 njira osokoneza Kupambana VBA mapasiwedi.

Gawo 1: Momwe Mungachotsere Mawu Achinsinsi a Project VBA mu Excel Popanda Mapulogalamu

Kutsegula pulojekiti ya VBA ku Excel kutha kuchitidwa mothandizidwa ndi pulogalamu ya VBA decryption yokha kapena ndi njira zamanja. Kufufuza momwe mungasokonezere mawu achinsinsi a Excel VBA pamanja, pali njira zingapo zabwino zogwirira ntchitoyo. Mutha kusankha pazosankha izi ndikuyesa ndi fayilo yanu yotetezedwa ya Excel. Pamapeto pake, imodzi mwazosankhazi ingakhale yabwinoko, kutengera mtundu wa chikalata chanu chotetezedwa komanso kufunikira komwe kulipo. Musanagwiritse ntchito njira zamabuku awa, muyenera kusunga mafayilo anu a Excel.

Njira 1. Sinthani fayilo yowonjezera kuti mutsegule gawo la Excel VBA

Njirayi ikuphatikizapo kusintha fayilo ya .xlsm ku mtundu wina ndikubwerera ku mtundu wa .xlsm pambuyo pake. Ngakhale njirayi ndi yayitali, mutha kuyitsatira mosamala kuti muchotse password yanu ya Excel VBA pamapeto pake. Masitepe otsatirawa akuwonetsa momwe mungaswere mawu achinsinsi a projekiti ya Excel VBA mwa kungosintha kuwonjezera mafayilo.

Gawo 1 : Pezani fayilo ya target .xlsm ndikusintha fayilo ya .xlsm ku zip.

Gawo 2 : Tsopano tsegulani fayiloyi kudzera mu pulogalamu iliyonse ya Archiver yomwe muli nayo. Mutha kugwiritsa ntchito WinRAR kapena 7-Zip. Mukachita izi, muyenera kuwona mawonekedwe otsatirawa a fayilo yanu.

Gawo 3 : Yendetsani ku chikwatu cha XL ndikuchotsani fayilo yolembedwa "VBAProject.bin".

Gawo 4 : Tsegulani fayilo ya VBAProject.bin kudzera mumkonzi uliwonse wa hex ndikuwona mawu akuti "DPB=" mkati mwa fayilo mu hex editor.

Gawo 5 : Mukapeza mawuwa, ingofafanizani ndikusintha ndi “DPX="” m'malo mwake. Tsopano sungani ndikutseka fayilo yanu mu hex editor. Imalembanso VBAProject.bin yakale ndi VBAProject.bin yosinthidwa ndi hex.

Gawo 6 : Bwezerani fayilo yowonjezera ku .xlsm ndiyeno mutsegule mu Excel. Pazenera lochenjeza, sankhani "Inde" ndikunyalanyaza zosankha zina.

Gawo 7 : Thamangani mkonzi wa VBA ndikusankha "Chabwino" ngati bokosi la zokambirana likuwonekera.

Gawo 8 : Dinani kumanja dzina la polojekiti yanu ya VBA ndikusankha katundu. Sankhani tabu "Chitetezo" ndikuchotsa mapasiwedi omwe alipo. Komanso, zimitsani bokosi la "Lock Project for Viewing" ndikuyambitsanso. Lowetsani mawu achinsinsi oyenera ndikutsimikizira. Dinani "Chabwino" kuti kusintha.

Njira 2. Chotsani Excel VBA Project Password ndi Hex Editor

Hex Editor imakupatsirani nsanja yabwino yosinthira zinthu za hex ndikuphwanya mawu achinsinsi a Excel VBA. Mwanjira iyi, mupanga fayilo ya dummy xls, ikani mawu achinsinsi, ndikuigwiritsa ntchito kuti mupeze Excel yotetezedwa.

Gawo 1 : Gwiritsani ntchito mkonzi wa Hex kuti mupange fayilo yatsopano ya Excel (xls). Fayilo yosavuta ingathe kuchita.

Gawo 2 : Pangani mawu achinsinsi pa fayiloyi mu gawo la VBA. Mutha kukanikiza Alt+F11 kuti mupeze njirayi.

Gawo 3 : Mukapanga mawu achinsinsi osavuta kukumbukira, sungani fayilo yatsopanoyi ndikutuluka.

Gawo 4 : Tsegulani fayilo yatsopanoyi, koma nthawi ino, tsegulani kudzera pa hex editor. Mukatsegula, pezani ndi kukopera mizere, yomwe imayamba ndi makiyi otsatirawa: CMG=, DPB= ndi GC=.

Gawo 5 : Tsopano tsegulani fayilo ya Excel momwe mukufuna kusokoneza mawu achinsinsi ndi mkonzi wa Hex. Matani malemba amene anakopedwawo m’magawo omwewo ndikusunga zosinthazo. Tulukani fayilo.

Gawo 6 : Nthawi zambiri tsegulani fayilo ya Excel ndikugwiritsa ntchito mawu achinsinsi omwe mudapanga pa fayilo ya dummy xls kuti muwone khodi ya VBA.

Njira 3. Chotsani achinsinsi ku Excel VBA polojekiti ndi Visual Basic Editor

Mosiyana ndi mkonzi wa Hex, Visual Basic Editor imalola ogwiritsa ntchito kusintha zilembo m'malo mwa hexadecimal. Mchitidwewu si wautali choncho. Komabe, muyenera kusamala chifukwa ma code amafunikira chisamaliro kuti mupewe zolakwika. Masitepe otsatirawa akuwonetsa bwino momwe mungaswe chinsinsi cha Excel Macro ndi Visual Basic Editor.

Gawo 1 : Tsegulani pamanja buku lothandizira lomwe lili ndi pepala lotetezedwa la Excel.

Gawo 2 : Tsopano tsegulani Visual Basic Editor pogwiritsa ntchito lamulo la Alt+F11. Pitani ku Embed Module ndiyeno muyike kachidindo zotsatirazi pazenera la code lomwe likupezeka kumanja.

Gawo 3 : Tulukani zenera la VBA Editor ndikupitiliza ndi tsamba lotetezedwa.

Gawo 4 : Pitani ku Zida> Macro> Macros. Pamndandanda womwe umawonekera, dinani kawiri pa "PasswordBreaker". Muyenera tsopano kupeza fayilo yanu ya Excel yotetezedwa ndi mawu achinsinsi.

Gawo 2: Zochepa pamanja potsegula VBA polojekiti mu Excel

Ngakhale njira Buku ndi zothandiza akulimbana Kupambana VBA mapasiwedi, iwo palibe paliponse pafupi wangwiro. Njirazi zimakhala ndi zovuta zingapo zomwe zimawapangitsa kukhala osakwanira akafika pamafayilo ofunikira komanso ovuta a Excel. Zotsatirazi ndi zina mwazolephera zomwe zimalepheretsa njira zamanja.

• Pamafunika chidziwitso chaukadaulo : Monga momwe mwawonera, zambiri mwazomwe zili pamwambapa zimaphatikizapo ma code ambiri. Kotero ngati muli ndi chidziwitso chochepa chaukadaulo, mudzakhala ndi nthawi yovuta ndi zosankha zamanja izi.
• Zimawononga nthawi yambiri : Njira zambiri zamanja zimaphatikizapo njira zazitali. Mfundo yakuti imakhudzanso ma code ndi kuyenda kudutsa mapulatifomu angapo kumapangitsa kuti ikhale yotopetsa kwambiri ndipo chifukwa chake ogwiritsa ntchito amawona kuti ikuchedwa komanso yotopetsa.
• Mtengo wopambana : Chofunikira, pamapeto pake, ndikuti titha kusokoneza mawu achinsinsi a Excel VBA kapena ayi. Tsoka ilo, zosankha zamanja izi zimalemba zopambana zotsika kwambiri. Choncho, sikoyenera kuthera nthawi yochuluka ndi mphamvu ndiyeno osapeza zotsatira zomwe mukufunikira.

Izi zati, ngati zosankha zonse zikulephera kapena mutatopa ndi zophophonya zawo, kenako yesani kugwiritsa ntchito mapulogalamu apadera monga Passper for Excel kuti muphwanye mawu achinsinsi a Excel VBA.

Gawo 3: Kodi Crack Kupambana VBA Achinsinsi basi

Passper kwa Excel ndi chida champhamvu kwambiri chotsegula mawu achinsinsi pamafayilo a Excel. Pulogalamuyi imatsimikizira kupambana kwa 100% kuti muwononge mawu achinsinsi a projekiti ya Excel VBA. Ndi kuthamanga kwachangu kwambiri komanso kosavuta kugwiritsa ntchito, palibe chifukwa chokayikira kuthekera kwa Passper ya Excel. Ndikofunikiranso kudziwa kuti Passper for Excel itha kugwiritsidwa ntchito kusokoneza chikalata chotsegulira mawu achinsinsi pamafayilo a Excel.

Zofunikira za Passper za Excel:

• Zoletsa zonse zosintha ndi masanjidwe mu polojekiti yanu ya VBA, tsamba logwirira ntchito, kapena buku lantchito zitha kuzindikirika nthawi yomweyo.
• Ndi Passper for Excel, kungodina pang'ono kukulolani kuti muchotse chitetezo chachinsinsi pa projekiti yanu ya VBA.
• Deta yanu sidzakhudzidwa kapena kuonongeka pambuyo ntchito pulogalamu.
• Pulogalamuyi imagwirizana kwambiri. Mitundu yonse ya mafayilo a Excel kuphatikiza .xlsm, .xlsb, .xltx, .xltm imagwirizana nayo.

Passper ya Excel yathandizira ogwiritsa ntchito mamiliyoni ambiri padziko lonse lapansi. Ndipo yalandira ndemanga zabwino kuchokera kwa ogwiritsa ntchito. Musazengereze kuyesa tsopano.

Yesani kwaulere

Momwe mungachotsere password ya VBA mu Excel ndi Passper ya Excel

Gawo 1: Yambitsani Passper ya Excel pa PC yanu ndikudina "Chotsani Zoletsa".

Gawo 2: Pazenera latsopano, dinani batani la "Sankhani Fayilo" ndikutsatira malangizo omwe ali pazenera kuti mukweze fayilo yotetezedwa ya Excel VBA papulogalamu.

Gawo 3: Fayilo yotetezedwa yachinsinsi ikakwezedwa, dinani "Chotsani" njira kuti muchotse chinsinsi cha polojekiti ya VBA mufayilo yanu ya Excel.

Pulogalamuyi imangochotsa zoletsa mkati mwa masekondi. Mukamaliza, muyenera kuwona zidziwitso zopambana pansi pazenera.

Mapeto

Bukuli lafotokoza momveka bwino njira zina zomveka zosokoneza mapasiwedi a Excel VBA. Komabe, mawonekedwe ena ndi apamwamba kuposa ena chifukwa cha kuthekera kwawo kuthana ndi ma passwords ovuta a VBA, kugwiritsa ntchito mosavuta, komanso kusindikiza mitengo yopambana. Kuchokera pazomwe zaperekedwa pamwambapa, palibe amene angatsutse Passper kwa Excel monga yankho lenileni kung'amba Kupambana VBA polojekiti achinsinsi. Zonse zoyezera zimayika patsogolo pa zosankha zamanja. Sankhani Passper kwa Excel ndikuthetsa mavuto anu achinsinsi a VBA kwamuyaya.

Yesani kwaulere