ʻO kahi papahana Excel Visual Basic for Applications (VBA) he ʻōlelo papahana i hoʻohana ʻia i loko o Excel e hoʻomohala i nā papahana maʻalahi. Hoʻohana maʻamau ia e hoʻololi i nā hana paʻakikī a hoʻopau manawa paha i nā kaʻina hana automated, mālama manawa, a hoʻomaikaʻi i ka maikaʻi o ke kaʻina hōʻike. ʻO kēia mau papahana VBA, akā naʻe, hiki ke mālama ʻia i ka ʻōlelo huna, i mea e pale ai i kou pilikino a i ʻole e pale aku i ka uhaki ʻana i ka palapala hana mua. No laila, hiki ke paʻakikī i kekahi manawa ke hoʻomanaʻo i kēia mau ʻōlelo huna, no ka mea ua poina a nalowale paha nā mea hoʻohana i ka ʻōlelo huna a i ʻole nā kumu ʻē aʻe. No laila, e hōʻike ana kēia ʻatikala i nā ala maʻalahi hiki ke hoʻohana e wehe i ka ʻōlelo huna mai ka papahana Excel VBA.
ʻElua ʻano hihia āu e hālāwai ai i ka wā e hoʻāʻo ai e wehe i nā ʻōlelo huna mai nā papahana Excel VBA. E kamaʻilio mākou e pili ana i nā mea ʻelua i kēlā me kēia pae.
Mahele 1: Wehe i ka ʻōlelo huna Excel VBA Project me ka ʻike ʻole i ka ʻōlelo huna
No ka hana ʻana i kēia, hiki iā ʻoe ke lawe i kekahi mau ala, ʻekolu o ia mau mea penei:
Wehe i ka ʻōlelo huna Excel VBA Project ma hoʻokahi kaomi no nā faila XLS/XLSM
Nui nā polokalamu ma ka mākeke e hiki ke kōkua iā ʻoe e wehe i nā ʻōlelo huna mai ka papahana Excel VBA. ʻO kahi laʻana maikaʻi Passper no Excel , he hopena maʻalahi a maikaʻi hoʻi e hoʻopau koke i nā pale hoʻoponopono a me ka hoʻopono ʻana i kūkulu ʻia i loko o ka pepa haʻawina/puke hana e kahi code VBA.
ʻO kekahi o nā hiʻohiʻona nui o Pasper for Excel:
- Hiki ke wehe ʻia ka ʻōlelo huna papahana VBA ma kāu puke hana Excel me kahi kaomi maʻalahi .
- Hōʻoiaʻiʻo a 100% ka holomua holomua .
- Manaʻo ka hui Pasper ka palekana o ko lakou ʻikepili . ʻAʻole e nalowale ka ʻikepili a i ʻole leak i ka wā/ma hope o ke kaʻina hana wehe.
- Aia ka papahana i kahi ākea ākea . Kākoʻo iā .xls, .xlsx, .xlsm, .xlsb, .xltx, .xltm a me nā faila ʻē aʻe i hana ʻia e Microsoft Excel.
No ka hōʻike ʻana i ka maʻalahi o ka hoʻohana ʻana iā Passper for Excel, ua hoʻomākaukau mākou i kahi alakaʻi kikoʻī no ʻoe. ʻO ka mea mua, pono ʻoe e hoʻoiho i ka polokalamu a hoʻokomo iā ia ma kāu kamepiula.
KaʻAnuʻu 1. Once kau, oe e koho i ka "Wehe i ka palena" koho.
KaʻAnuʻu Hana 2. E hoʻohana i ke pihi "E koho i kahi faila" e hoʻouka i ka faila Excel i pale ʻia e ka password. Ke hoʻohui ʻia ka faila i ka polokalamu, kaomi wale i ke koho "Delete" e kāpae i ka pale ʻōlelo huna mai kāu pepa Excel.
KaʻAnuʻu 3. I loko o kekona, e wehe 'ia ka hua'ōlelo o ka papahana VBA mai kāu puke hana Excel.
Passper no Excel He polokalamu ikaika a hilinaʻi. Ua loaʻa iā ia nā loiloi maikaʻi mai nā mea hoʻohana. Mai kānalua e hoʻohana.
Wehe i ka ʻōlelo huna Excel VBA Project Online
ʻO kahi ala ʻē aʻe e wehe i ka ʻōlelo huna o ka papahana VBA ma kāu mau palapala Excel ʻo ka hoʻohana ʻana i kahi lawelawe pūnaewele i loaʻa ma ka pūnaewele. ʻO kahi laʻana maikaʻi o kēia ʻano mea paahana pūnaewele ʻo Office VBA Password Remover. ʻO kēia mea hana pūnaewele e kōkua iā ʻoe e hoʻopau i kāu pale, akā pono nā ʻanuʻu he nui. ʻO ke kaʻina hana penei:
KaʻAnuʻu 1: Kaomi iā "Open File" no ka hoʻouka ʻana i kāu faila Excel i pale ʻia e ka ʻōlelo huna VBA.
KaʻAnuʻu 2: Kaomi "Decrypt VBA" e hōʻoia i ka hoʻoiho ʻana i ka palapala hou.
KaʻAnuʻu 3: Ke hoʻoiho ʻia, wehe i ka palapala. E hoʻomanaʻo iā ʻoe aia ka pāhana i ke kī hewa ʻole. Kaomi "ʻAe" e hoʻomau.
KaʻAnuʻu 4: E kaomi i ka ALT+F11 e wehe i ka papahana VBA. I loko o ka puka aniani, ʻaʻole pono ʻoe e hoʻonui i ka papahana. A laila, e hele i Tools> VBA Project Properties.
KaʻAnuʻu 5: E hele i ka pale pale, e hoʻonoho i kahi ʻōlelo huna hou āu e koho ai a waiho i ka pahu pahu i koho ʻia.
KaʻAnuʻu 6: E mālama i ka palapala a pani i ka papahana VBA.
KaʻAnuʻu 7: E wehe hou i kāu puke hana Excel a hana hou i ka hana 4.
KaʻAnuʻu 8: I kēia manawa pono ʻoe e hoʻomaʻemaʻe i ka pahu pahu a me ka ʻōlelo huna ma ka ʻaoʻao "Protection".
KaʻAnuʻu 9: E mālama hou i ka palapala. Ua wehe ʻia ka ʻōlelo huna.
Nā pōʻino o kēia ʻano:
- He manawa lōʻihi ka hoʻouka ʻana i kāu faila Excel. Eia nō hoʻi, ʻaʻohe papa hana, no laila ʻaʻole hiki iā ʻoe ke ʻike inā ua hoʻouka ʻia kāu faila a ʻaʻole paha.
- ʻAʻole palekana ka hoʻouka ʻana i kāu faila Excel i kā lākou pūnaewele no kāu ʻikepili, ʻoi aku ka paʻakikī o kāu ʻikepili.
Wehe i ka ʻōlelo huna mai Excel VBA Project me ka hoʻohana ʻana i ka Lunahooponopono HEX
Hiki i ka mea hoʻoponopono hex ke lilo i mea hana pono inā makemake ʻoe e wehe lima i nā ʻōlelo huna mai kāu papahana Excel VBA. ʻElua ala ʻokoʻa e pono ai e wehe i nā ʻōlelo huna e pili ana i ka hoʻonui ʻano faila Excel. Ma mua o ka hoʻomaka ʻana i ke kaʻina hana, e hoʻomanaʻo mau i ka hana ʻana i kahi waihona o nā faila Excel āu e hana nei.
Inā ʻo XLS ke ʻano faila:
KaʻAnuʻu 1: E wehe i ka waihona .xls i pale ʻia me ka ʻōlelo huna me ka hoʻoponopono hex a nānā i ke kaula "DPB."
KaʻAnuʻu 2: E hoʻololi i ka "DPB" me "DPX".
KaʻAnuʻu 3: E mālama i ka faila a haʻalele i ka mea hoʻoponopono.
KaʻAnuʻu 4: A laila, wehe i ka faila me Microsoft Excel. E hōʻike ʻia nā leka hewa he nui, he mea maʻamau. E ʻoluʻolu e kaomi iā lākou.
KaʻAnuʻu 5: I kēia manawa e kaomi i ka ALT + F11 e wehe i ka puka makani papahana VBA a kaomi i nā waiwai VBAProject mai ka papa kuhikuhi Mea Hana.
KaʻAnuʻu 6: Ma ka pale pale, hoʻololi i ka ʻōlelo huna i kahi mea maʻalahi a maʻalahi hoʻi e hoʻomanaʻo.
KaʻAnuʻu 7: E mālama i ka puke hana a haʻalele i ka puka makani.
KaʻAnuʻu 8: E wehe hou i ka puke hana Excel a komo i ka puka makani papahana VBA ma ke kaomi ʻana iā ALT+F11 a hoʻokomo i ka ʻōlelo huna āu i hoʻololi ai. E hana hou i ka hana 6, akā i kēia manawa hiki iā ʻoe ke wehe i ka ʻōlelo huna.
KaʻAnuʻu 9: E mālama i ka puke hana a loaʻa iā ʻoe kahi faila Excel me ka ʻōlelo huna.
Inā ʻo XLSM ke ʻano faila:
No nā hoʻonui .xlsm, pono kahi ʻanuʻu hou i ka hoʻomaka. Ma lalo mākou e hāʻawi iā ʻoe i kahi alakaʻi i kēlā me kēia ʻanuʻu.
KaʻAnuʻu 1: E hoʻololi i ka hoʻonui o kāu faila .xlsm i .zip. A laila wehe iā ia me 7Zip a i ʻole WinZip.
KaʻAnuʻu 2: E huli a kope i ka faila "xl/vbaProject.bas" a i ʻole "xl/vbaProject.bin" mai ka faila zip. E hōʻoia i ka wehe ʻana o ka waihona zip.
KaʻAnuʻu 3: Kaomi a wehe i ka faila "xl/vbaProject.bas" a i ʻole "xl/vbaProject.bin" me ka hoʻoponopono hex.
KaʻAnuʻu 4: E huli i ke kaula "DPB" a hoʻololi iā ia me "DPX".
KaʻAnuʻu 5: E mālama i ka faila, a kope hou i ka waihona Zip (hiki iā ʻoe ke kauo a hoʻokuʻu i ka faila i loko o ka waihona).
KaʻAnuʻu 6: I kēia manawa, hoʻopaʻa i nā faila āpau i loko o kahi faila Zip hou. A laila, hoʻololi i ka hoʻonui faila i .xlsm.
KaʻAnuʻu 7: A laila, wehe i ka faila .xlsm. E hōʻike ʻia nā leka hewa like ʻole. Kaomi "ʻAe" e hoʻomau.
KaʻAnuʻu 8: E kaomi i ka ALT+F11 e wehe i ka papahana VBA a kaomi i ka VBAProject Properties ma ka papa kuhikuhi Mea Hana.
KaʻAnuʻu 9: E wehe i ka pale pale, wehe i ka "Lock project for viewing" a kaomi iā OK.
KaʻAnuʻu 10: E mālama i ka faila .xlsm a pani i ka puka makani
Nā pōʻino o kēia ʻano:
- Nui nā mea hoʻoponopono hex ma ka pūnaewele. He hana paʻakikī ke koho ʻana i kahi mea maikaʻi inā ʻaʻohe ʻike loea.
- Ua hōʻike kekahi mau mea hoʻohana ʻaʻole hiki iā lākou ke hoʻoiho i ka hoʻoponopono hexadecimal. No laila, ʻaʻole pono mau kēia ʻano hana iā ʻoe.
Mahele 2: Wehe i ka ʻōlelo huna Excel VBA Project me ka ʻōlelo huna
He mea maʻalahi kēia hihia e hoʻokō a like me kā mākou kūkākūkā mua. No ka maʻalahi o ka hoʻomaopopo ʻana, wehewehe ʻia ke kaʻina hana ma lalo nei:
KaʻAnuʻu 1: E wehe i kāu puke hana Excel me Microsoft Excel. E kaomi iā Alt+F11 e komo i ka papahana VBA.
KaʻAnuʻu 2: E hele i nā mea hana> VBAProject Properties. E hoʻokomo i ka ʻōlelo huna pololei ma ka pahu kamaʻilio VBAProject Password.
KaʻAnuʻu 3: E hele i ka pale pale, wehe i ka "Lock project for viewing" a hoʻopau i ka ʻōlelo huna ma nā pahu aʻe.
KaʻAnuʻu 4: Kaomi "OK" a mālama i ka hana. ʻo ia wale nō.
Ka hopena
He hana weliweli paha ka wehe ʻana i nā ʻōlelo huna o ka papahana VBA mai nā faila Excel. Manaʻo mau ʻia e hoʻohana i kahi hopena kūpono a maʻalahi hoʻi i ka wā e pili ana i kēia mau faila. Mālama kēia i ka manawa nui a ʻoi aku ka maʻalahi. E ho'āʻo i kēia manawa Passper no Excel a e hauʻoli loa ʻoe.
