Whakarāpopototanga: E whakamārama ana tēnei tuhinga i ngā mea katoa mō te tiaki kupuhipa o te kaupapa VBA. He mea whai hua tēnei mō te hunga e hiahia ana kia haumaru tā rātou kōnae Excel, ā, kāore e hiahia kia uru atu ētahi atu me te kore whakaaetanga. Ka matapakihia hoki e tātou ngā here o te tiaki kupuhipa.
Tiakina ō Macros VBA ki tēnei Tinihanga
Raruraru: Kāore au e hiahia kia uru atu tetahi ki taku pepa Excel, kia whakatika, kia whakarerekē rānei i tētahi o ngā waehere makaro kua whakanohoia ki roto. Me aha ahau?
Me pēhea: He otinga tino māmā tēnei mō te raruraru i runga ake nei. Tiakina tō kaupapa VBA i roto i te Excel mā te kupuhipa hei ārai i ngā huringa kāore i whakamanahia (tirohia ngā whakaahua mata i raro nei).
Ka mahi anō hoki tēnei mō ētahi atu taupānga Microsoft Office pērā i a Access, Word, me ētahi atu.
Hipanga 1. Whakatuwheratia te pukapuka mahi Microsoft Excel kei roto nei tō kaupapa VBA.
Hipanga 2. Pēhia te Alt+F11 hei whakatuwhera i te matapihi Microsoft Visual Basic mō ngā Taupānga.
Ka taea rānei e koe te pēhi i te ripa "Kaiwhakawhanake" > te pātene "Visual Basic".
Hipanga 3. I te matapihi Microsoft Visual Basic for Applications e tuwhera ana, haere ki "Ngā Utauta" > "Ngā Āhuatanga VBAProject".
Hipanga 4. I te pouaka kōrero "VBAProject" e puta mai ana, pāwhiritia te "Parenga" i te pou matau, ka tohua te kōwhiringa "Maukati kaupapa hei tiro".
Patohia he kupuhipa ki te pouaka tuhinga i raro i tēnei kōwhiringa, ka pato anō hei whakaū. Kātahi ka pēhi i te "ĀE" hei kati.
Puritia tēnei kupuhipa kia tata mai! Ka hiahiatia tēnei hei whakatuwhera i tō kaupapa Excel VBA.
Hipanga 5. Ka taea e koe te kati i te matapihi Microsoft Visual Basic for Applications. Whai muri i tēnā, pāwhiritia te pātene "Tiaki" kei te kokonga maui o runga o Excel. Kātahi ka kati i te pukapuka mahi Excel.
Koia kē. Koinei te huarahi e tiakina ai tō kaupapa VBA mā te kupuhipa i roto i te Excel.
Ka tūtohu mātou kia whakatuwheratia anō e koe te pukapuka mahi Excel kia mōhio ai kei te tiakina tika te kaupapa VBA.
Ki te hiahia koe ki te iriti i tō kaupapa VBA, tangohia noa te parenga kupuhipa ka pēhi anō i te "Tiaki" hei whakahou i ngā huringa.
Te Tiakitanga Kupuhipa VBA me ōna Here
Ahakoa kua hiritia tō waehere VBA ki te kupuhipa, he ngoikoretanga anō kei tēnei tikanga—Kāore e taea te aukati i te hunga e hiahia ana ki te uru atu ki tō kaupapa.
Tērā pea ka uru tonu mai tētahi ki tō pukapuka mahi Excel me te kore e mōhio ki te kupuhipa. Hei tauira, Ngā tango kupuhipa VBA ka taea te wetewete i tō kōnae me te tautuhi anō i tō kupuhipa. Mā te rapu tere ka kitea he maha ngā taputapu pēnei e wātea ana i te mākete, he mea arumoni, he mea kore utu hoki.
Ae, he tino whai hua te tiakitanga kupuhipa mō te nuinga o te hunga kāore e hiahia kia whakarerekētia ā rātou waehere. Heoi, me mōhio koe ki ōna herenga mēnā kei te whakamahi koe hei tiaki i ngā raraunga tairongo, i ngā taonga hinengaro rānei. Nō reira, kia pai ake ai te tiaki i tō waehere VBA i roto i te Excel, ko te otinga pai ko te huri ki tētahi kōnae C/C++. Tērā pea ka kitea e koe he maha atu ngā kōwhiringa mō te tiaki i tō waehere VBA mai i te hononga.
