Ko te waehere VBA e tuhia ana e koe te ngākau me te wairua o tō ripanga tātaitai. Me tiaki te waehere VBA kia kore ai tō waehere e tahaetia, e whakamahia rānei me te kore e mōhiotia e koe. Ka hipokina e tēnei pou ētahi huarahi rerekē hei tiaki i tō waehere VBA kia taea ai e KOE anake te uru atu.
He aha koe me aro nui ai ki te tiaki i te waehere VBA?
He reo makro te VBA ka taea te whakamahi hei waihanga i ngā mahi aunoa i roto i te Excel, Word, PowerPoint. He maha ngā take me tiaki e koe tō waehere VBA:
- Hei tiaki i tō waehere VBA mai i te whakarerekētanga tūpono. He taputapu kaha te waehere VBA mō ngā kaiwhakamahi Excel, engari ka taea hoki te waiho hei pūtake o te riri mō te hunga kāore e whakamahi. Ki te kore koe e tiaki i te VBA ki te kupuhipa, ka taea e ētahi atu e whakamahi ana i tō pukapuka mahi te uru atu ki te waehere me te hanga huringa ki roto me te kore e mōhio ki tā rātou e mahi ana. Kāore koe e hiahia ki te patuiro i tō waehere VBA nā te mea he uaua pea - tera pea ka roa ngā hāora ki te rapu i te take, ā, ka roa ake te wā!
- Hei tiaki i tō taonga hinengaro. He tino whai hua te waehere VBA ki ētahi kamupene. Mēnā ka uru atu tētahi atu ki tō ripanga tātai, ā, ka tārua i te mahi e whakamahia ana e koe, tera pea ka tukuna e rātou hei mahi nā rātou ake, ka hokona atu ki te tini o ngā kamupene. Tiakina tō waehere pūtake whai hua me ngā mahi haumarutanga. Kaua e whakangawari i te tahae, i te tārua rānei a tetahi.
- Hei tiaki i a koe mai i te hunga e whakamahi ana i tāu mahi. Mena kei a koe tētahi waehere VBA whai hua hei whakahaere i tāu mahi kia māmā ake ai, kia pai ake ai rānei, me tiaki pea mō te whakamahinga whaiaro anake.
He mea nui kia mōhio koe he maha ngā huarahi hei tiaki i tō waehere VBA, engari kāore e rite katoa te tiaki i tō waehere. Kei a koe te tikanga me te mea e pai ana mō ō hiahia.
#1 Te Tiaki Kupuhipa i te Waehere VBA i roto i te Excel mā te whakamahi i te Utauta VBAProject
E whakamārama ana tēnei wāhanga me pēhea te whakamahi i ngā tautuhinga tiaki kaupapa VBA hei tiaki i tō waehere VBA mai i ngā kanohi whāwhā me ngā ringa tāhae.
- Taumata haumarutanga: Ngoikore; He taputapu pēnei i te Tango Kupuhipa VBA ka taea te whakamahi hei iriti i te kupuhipa i roto i ngā meneti;
- Uauatanga: Ngāwari;
- Utu: Kore utu;
Hipanga 1. Tīpakohia te "Visual Basic" mai i te tahua "Developer" i roto i te Excel.
Hipanga 2. Hei raka i tō kaupapa VBA, pāwhiritia "Ngā Utauta" i te pae, kātahi ka tīpako i "Ngā Āhuatanga o te VBAProject".
Whai muri i te pāwhiri i tēnei tūemi tahua, me kite koe i te pouaka kōrero e whai ake nei:
Ka tīpakohia te ripa "Whānui" mā te taunoa, engari pāwhiritia te ripa "Parenga".
Hipanga 3. Tīpakohia "Lock project for viewing" kātahi ka patohia tō kupuhipa kia rua ngā wā ki roto i ēnei pouaka e rua, kātahi ka pēhi i te "OK".
Hipanga 4. Tiakina, ka whakatuwhera anō i te kōnae Excel. Ka taea e koe te kite mēnā i whakahohea tika te tiakitanga kupuhipa VBA mā te pāwhiri-rua i tō kaupapa VBA. Mā te tiaki i tō kaupapa VBA ki te kupuhipa, ka ārai i tētahi atu kei whakarerekē tūpono.
#2 Whakamahia te VBA Obfuscation hei Tiaki i tō Waehere Macro
Ko te whakapōrearea VBA te toi o te hanga i tō waehere VBA kia kore e taea te pānui engari kei te mahi tonu. Ka whakarerekētia e ia ō macros o nāianei me ngā taumata whakapōrearea maha, ka uaua ai te mārama ki te ariā matua. Ka whakamahia e ngā whakapōrearea VBA matatau he maha ngā tikanga whakapōrearea matatau, ka nui ake te uaua o te whai me te whakaora whakamuri.
- Taumata haumarutanga: Waenga; Ka taea tonu e te tangata te whai wā me te whakapau rauemi hei whakaora i te waehere;
- Uauatanga: Taurite; I runga i te taumata;
- Utu: VBA Obfuscator Koreutu /Premium;
Ka taea e koe te whakamahi i te VBA obfuscation i te taha o te tikanga #1, arā, ko te huna tuatahi i te kōwae, kātahi ka tiakina ki te kupuhipa. Kia maumahara kāore e taea te whakakore i te huna, nō reira me tārua te kōnae pūtake i mua i te haere tonu. Kia maumahara hoki kāore e taea te kī taurangi ka whakahaerehia te waehere huna me te kore he hapa. Whakamātauria kia tino pai i mua i te tukunga. Whakamahia he wāhanga kotahi o te kaupapa hei huna. Kia angitu te whakamātautau huna kōwae tuatahi, neke atu ki te tuarua.
#3 Tahurihia te Waehere VBA ki te Whare Pukapuka Hononga-Hihiri (DLL)
Ka whakaputahia e ngā kaiwhakaemi pērā i a Visual C++ me Visual Basic ngā tono he uaua ki te pakaru. Nā te mea ka whakahiatohia te waehere ki roto i ngā kōnae whakahaere, ki ngā kōnae whare pukapuka hononga hihiri rānei. Nō reira, ka taea hoki e tātou te whakahiato i te waehere VBA ki roto i tētahi kōnae whare pukapuka hononga hihiri, kātahi ka whakamahia ki roto i te Excel.
- Taumata haumarutanga: Teitei;
- Uauatanga: Taurite;
- Utu: Kore utu;
E tino taunakihia ana tēnei tikanga tiaki, engari kāore i te tino taurangihia. Ki te hiahia koe ki te ako me pēhea te whakahiato, tirohia ngā tohutohu i VbaCompiler.com: 10 ngā taahiraa hei whakahiato i te waehere VBA ki roto i te DLL Windows taketake .
#4 Tahurihia te VBA ki te C, ki te C++ rānei
He uaua ake te hanga whakamuri i te whakamāori i ō makaro ki te C, ki te C++ rānei, i te VBA. Ki te hiahia koe ki te tiaki i tō waehere, koinei te huarahi pai.
- Taumata haumarutanga: Teitei rawa; He tata kore e taea te tiki i te waehere me te kore he mana; Engari anō, kāore i te 100% te kī taurangi;
- Uauatanga: He uaua, he roa hoki te wā e pau ana; Nā te mea he rerekē rawa ngā reo o VBA me C/C++, he uaua ake nā te mea me whakapau kaha koe.
Whakamutunga
He huarahi pai te whakamahi i ngā macros hei whakahaere i te whanaketanga o ngā mahi matatau. Engari, ka tūpono tō waehere ki te tahaetia, ki te tāruatia rānei e ētahi atu. E matapakihia ana e te tuhinga ngā tikanga ka taea e koe te whakamahi hei ārai i ētahi atu kaiwhakamahi kei tahaetia, kei whakararuraru rānei i tō waehere VBA. Kia mōhio koe, ehara ngā parenga waehere VBA i te parenga ātete, engari ka whakaratohia he parenga ki ngā kaiwhakaeke noa.
