Mashruuca Excel Visual Basic for Applications (VBA) waa luqad barnaamij lagu isticmaalo gudaha Excel si loo horumariyo barnaamijyo fudud. Caadi ahaan waxa loo isticmaalaa in lagu beddelo shaqooyinka adag ama waqti-qaadka ah ee loo beddelo hab-raacyo toos ah, waqti-badbaadin ah, iyada oo kor u qaadeysa tayada habka warbixinta. Si kastaba ha ahaatee, mashaariicdan VBA, si kastaba ha ahaatee, mararka qaarkood waxaa lagu ilaalin karaa erayga sirta ah, si loo ilaaliyo qarsoodigaaga ama si looga hortago xadgudub kasta oo ka mid ah qoraalka shaqada ee asalka ah. Sidaa darteed, mararka qaarkood way adkaan kartaa in la xasuusto furaha sirta ah, sababtoo ah isticmaalayaashu waxay illoobeen ama lumiyeen erayga sirta ah ama sababo kale oo kala duwan. Sidaa darteed, maqaalkani wuxuu muujin doonaa siyaabaha kala duwan ee fudud ee loo isticmaali karo in laga saaro erayga sirta ah ee Excel VBA mashruuca.
Waxaa jira laba nooc oo kiisas ah oo laga yaabo inaad la kulanto markaad isku dayeyso inaad ka saarto furaha sirta ah ee mashaariicda Excel VBA. Labada arrimoodba tallaabo tallaabo ayaan uga hadli doonnaa.
Qeybta 1: Ka saar erayga sirta ah ee mashruuca Excel VBA adiga oo aan aqoon sirta
Si taas loo sameeyo, waxaad qaadan kartaa dhowr habab oo saddex ka mid ah ay yihiin kuwan soo socda:
Ka saar erayga sirta ah ee Mashruuca VBA ee Excel hal guji oo loogu talagalay faylasha XLS/XLSM
Waxaa jira barnaamijyo badan oo suuqa ka jira oo kaa caawin kara inaad ka saarto furaha sirta ah mashruuca VBA ee Excel. Tusaale wanaagsan ayaa ah Passper ee Excel , kaas oo ah xal fudud oo wax ku ool ah si isla markaaba looga takhaluso dhammaan ilaalinta tafatirka iyo qaabaynta ee lagu dhex dhisay xaashida shaqada/buugga shaqada ee code VBA.
Qaar ka mid ah sifooyinka ugu muhiimsan ee Passper for Excel waa:
- Furaha mashruuca VBA ee ku jira buuggaaga shaqada ee Excel waa laga saari karaa adigoo gujinaya fudud .
- Dammaanad a 100% heerka guusha .
- Kooxda Baasaboorka ayaa danaynaya amniga ee iyaga xogta . Ma jiri doono lumin xog ama daadin inta lagu jiro/ka dib habka saarista.
- Barnaamijku wuxuu leeyahay a waafaqid ballaaran . Waxay taageertaa .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm iyo faylasha kale ee ay abuurtay Microsoft Excel.
Si loo muujiyo sida ay u fududahay in loo isticmaalo Passper for Excel, waxaan kuu diyaarinay hage faahfaahsan. Marka hore waa in aad soo dejiso barnaamijka oo aad ku shubtaa kombayutarkaga.
Tallaabada 1. Marka la rakibo, waa inaad doorataa ikhtiyaarka "ka saar xayiraadaha".
Tallaabada 2. Isticmaal badhanka "Dooro faylka" si aad u geliso faylka Excel ee erayga sirta ah ilaaliyo. Marka faylka lagu daro software-ka, si fudud u dhagsii ikhtiyaarka "Delete" si aad uga takhalusto ilaalinta eraygaaga sirta ah xaashida Excel.
Tallaabada 3. Ilbiriqsiyo gudahood, erayga sirta ah ee mashruuca VBA ayaa laga saari doonaa buuggaaga shaqada ee Excel.
Passper ee Excel Waa barnaamij awood leh oo la isku halayn karo. Waxay ka heshay dib u eegis togan isticmaalayaasha. Ha ka waaban inaad isticmaasho.
Ka saar erayga sirta ah ee Mashruuca VBA ee Excel Online
Habka kale ee meesha looga saaro erayga sirta ah ee mashruuca VBA ee dukumeentigaaga Excel waa inaad isticmaasho adeeg online ah oo laga heli karo shabakada. Tusaalaha wanaagsan ee noocan ah aaladaha khadka tooska ah waa Xafiiska VBA Password Remover. Qalabkan khadka tooska ah wuxuu kaa caawinayaa inaad ka takhalusto ilaalintaada, laakiin waxay u baahan tahay tillaabooyin badan. Nidaamku waa kan soo socda:
Tallaabada 1: Guji "Faylka Furan" si aad ugu shubto mashruucaaga VBA-ga ee eraygaaga sirta ah lagu ilaaliyo faylka Excel.
Tallaabada 2: Guji "Decrypt VBA" si aad u xaqiijiso soo dejinta dukumeentiga cusub.
Tallaabada 3: Marka la soo dejiyo, fur dukumeentiga. Waxay ku xasuusin doontaa in mashruucu ka kooban yahay furaha aan sax ahayn. Guji "Haa" si aad u sii wadato.
Tallaabada 4: Riix ALT+F11 si aad u furto mashruuca VBA. Daaqadda macro gudaheeda, waa inaadan ballaarin mashruuca. Marka xigta, aad Tools>VBA Project Properties.
Tallaabada 5: Tag tab ilaalinta, deji furaha sirta ah ee cusub ee aad dooratay oo ka tag sanduuqa jeeg-bixinta ee la doortay.
Tallaabada 6: Kaydi dukumeentiga oo xidh mashruuca VBA.
Tallaabada 7: Mar labaad fur buuggaaga shaqada ee Excel oo ku celi tallaabada 4.
Tallaabada 8: Markan waxaad u baahan tahay inaad nadiifiso sanduuqa hubinta iyo meelaha sirta ah ee ku yaal tab "Ilaalinta".
Tallaabada 9: Kaydi dukumeentiga mar kale. Furaha sirta ah waa la saaray
Khasaarooyinka habkan:
- Soo dejinta faylkaaga Excel waxay qaadan doontaa waqti. Sidoo kale, ma jiro wax ka baaraandegi kara, markaa ma sheegi kartid in faylkaaga la soo geliyay iyo in kale.
- Ku dhejinta faylkaaga Excel mareegaha ammaan uma aha xogtaada, gaar ahaan marka xogtaadu xasaasi tahay.
Ka saar erayga sirta ah Mashruuca VBA ee Excel Adigoo isticmaalaya HEX Editor
Tifaftiraha hex wuxuu noqon karaa qalab waxtar leh haddii aad rabto inaad gacanta ka saarto furaha sirta ah mashruucaaga VBA ee Excel. Waxaa jira laba hab oo kala duwan oo loo baahan yahay si meesha looga saaro furaha sirta ah ee ku saleysan nooca faylka Excel. Kahor intaadan bilaabin habka buug-gacmeedka, had iyo jeer xasuuso inaad kaydiso faylasha Excel ee aad la shaqaynayso.
Haddii nooca faylka uu yahay XLS:
Tallaabada 1: Ku fur faylka .xls ee furaha lagu ilaaliyo oo wata hex editor oo raadi xadhigga "DPB."
Tallaabada 2: Ku beddel "DPB" "DPX".
Tallaabada 3: Kaydi faylka oo ka bax tafatiraha
Tallaabada 4: Marka xigta, ku fur faylka Microsoft Excel. Ogeysiisyo khaladaad badan ayaa soo bixi doona, taasoo caadi ah. Hubi inaad gujiso iyaga.
Tallaabada 5: Hadda taabo ALT + F11 si aad u furto daaqada mashruuca VBA oo guji guryaha VBAProject ka menu-ka Qalabka.
Tallaabada 6: Bogga Ilaalinta, u beddel erayga sirta ah wax fudud oo fudud in la xasuusto.
Tallaabada 7: Keydi buugga shaqada oo ka bax daaqadda.
Tallaabada 8: Dib u fur buugga shaqada ee Excel oo gal daaqada mashruuca VBA adiga oo riixaya ALT+F11 oo geli erayga sirta ah ee aad hadda bedeshay. Ku celi tallaabada 6, laakiin markan waxaad ka saari kartaa erayga sirta ah.
Tallaabada 9: Keydi buugga shaqada oo hadda waxaad haysataa faylka Excel bilaa sirta ah.
Haddii nooca faylka uu yahay XLSM:
Kordhinta .xlsm, tallaabo dheeraad ah ayaa loo baahan yahay bilowga. Hoos waxaan ku siinaynaa hage tallaabo-tallaabo ah.
Tallaabada 1: U beddel kordhinta faylkaaga .xlsm .zip. Kadibna ku fur 7Zip ama WinZip.
Tallaabada 2: Soo hel oo koobi ka samee faylka “xl/vbaProject.bas” ama “xl/vbaProject.bin” faylka zip-ka Hubi in faylka sibka uu wali furan yahay.
Tallaabada 3: Guji oo fur faylka "xl/vbaProject.bas" ama "xl/vbaProject.bin" adoo isticmaalaya tifaftiraha hex.
Tallaabada 4: Soo hel xadhigga “DPB” oo ku beddel “DPX”.
Tallaabada 5: Keydi faylka, oo koobi ku soo celi galka Zip-ka (waxaad jiidi kartaa oo ku ridi kartaa faylka galka).
Tallaabada 6: Hadda, sib dhammaan faylasha ku jira galka gal faylka Zip cusub. Marka xigta, u beddel kordhinta faylka .xlsm.
Tallaabada 7: Marka xigta, fur faylka .xlsm. Ogeysiisyo khaladaad kala duwan ayaa soo bixi doona. Guji "Haa" si aad u sii wadato.
Tallaabada 8: Riix ALT+F11 si aad u furto mashruuca VBA oo dhagsii VBAProject Properties ee ku yaal liiska agabka.
Tallaabada 9: Fur ilaalinta tab, ka saar "Project Lock for viewing" oo tabo OK.
Tallaabada 10: Kaydi faylka .xlsm oo xidh daaqada
Khasaarooyinka habkan:
- Waxaa jira tifaftirayaal badan oo hex ah oo ku yaal mareegaha. Doorashada mid wanaagsan waa hawl adag haddii aanad aqoon farsamo lahayn.
- Isticmaalayaasha qaar ayaa sheegay in aysan soo dejin karin tifaftiraha hexadecimal. Sidaa darteed, habkani mar walba faa'iido kuu yeelan maayo.
Qeybta 2: Ka saar Password-ka Mashruuca VBA ee Excel oo wata Password la yaqaan
Kiiskan waa uu fudud yahay fulinta wuxuuna la mid yahay dooddeennii hore. Si loo fududeeyo fahamka, habraaca ayaa lagu qeexay hoos:
Tallaabada 1: Ku fur buuggaaga shaqada ee Excel Microsoft Excel. Taabo Alt+F11 si aad u gasho mashruuca VBA.
Tallaabada 2: Tag Tools>VBAProject Properties. Geli erayga sirta ah ee saxda ah sanduuqa wada hadalka sirta ah ee VBAProject Password.
Tallaabada 3: Tag tabka Ilaalinta, ka saar "Mashruuca quful si aad u aragto" oo dami erayga sirta ah ee sanduuqyada soo socda.
Tallaabada 4: Guji "OK" oo badbaadi hawlgalka. Waa intaas.
Gabagabo
Waxay noqon kartaa hawl aad u xun in laga saaro furaha mashruuca VBA ee faylasha Excel. Had iyo jeer waxaa lagu talinayaa in la isticmaalo xal wax ku ool ah oo sahlan in la isticmaalo marka la macaamilayo noocyadan faylasha. Tani waxay badbaadinaysaa waqti badan waana tan ugu habboon. Isku day hadda Passper ee Excel aadna aad ula yaabi doontaa.
