Pono no ka mea polokalamu VBA

Inā ʻoe e haʻi i ka huaʻōlelo "macros" me ka hanu weliweli a me ka leo ma ka lua o ka huaʻōlelo, a ʻo ka huaʻōlelo "Visual Basic for Applications" e like me ka leo iā ʻoe, a laila ʻaʻole no ʻoe kēia ʻatikala. I kekahi hihia, i kēia manawa 🙂

Inā loaʻa iā ʻoe kekahi ʻike ma ka hoʻonohonoho ʻana i nā macros ma VBA ma Excel, a ʻaʻole ʻoe e hoʻolālā e hoʻōki, a laila pono ke koho ʻana i nā mea hoʻohui a me nā papahana ma lalo nei (ma ka liʻiliʻi loa) pono iā ʻoe.

MZ-Tools - "Swiss knife" no ka mea papahana

Ma hope o ka hoʻokomo ʻana i ka hoʻoponopono VBE ma ka papa kuhikuhi hana e hōʻike ʻia ka submenu Nā mea hana MZ a me kahi mea hana hou no ke komo wikiwiki ʻana i nā hana like:

ʻIke ʻo ia i ka hana nui. ʻO nā mea waiwai loa, i koʻu manaʻo:

• Hoʻohui 'akomi i ka "iʻa blank" e hana i nā kaʻina hana, nā hana, nā hanana a me nā mea hana hewa me ka inoa pololei o nā ʻano like me ka ʻōnaehana Hungarian.
  
• E kope i nā mana ma nā mea hoʻohana me kā lākou code.
  
• Hana i nā bookmarks (Pūnaewele) no nā kaʻina hana a neʻe koke iā lākou i kahi papahana nui.
• E hoʻokaʻawale i nā laina lōʻihi o ke code i mau ʻāpana a hui hou (e hoʻokaʻawale a hui pū i nā laina).
  
• E hoʻopuka i nā ʻikepili kikoʻī e pili ana i ka papahana (ka helu o nā laina o ke code, nā kaʻina hana, nā mea ma nā palapala, etc.)
• E nānā i ka papahana no nā loli a me nā kaʻina hana ʻole (Review Source)
• E hana i kāu kumu ponoʻī o nā code templates (Code Templates) no nā hihia maʻamau a hoʻokomo koke iā lākou i loko o nā macro hou ma hope.
• Hoʻokumu 'akomi i kahi kaula lōʻihi a weliweli e hoʻopili i nā kumu ʻikepili waho ma o ADO.
  
• Hoʻopili i nā kī wela i kekahi hana mai ka add-on.
  

He mea pono ʻole e loaʻa i ka mea papahana o kēlā me kēia pae. Inā loaʻa iā ʻoe ka mana hou loa o Office, a laila e ʻoluʻolu e hoʻoiho i ka mana hou loa o MZ-Tools 3.00.1218 i hoʻopaʻa ʻia ma Malaki 1, no ka mea. Ua hoʻoponopono ʻo ia i kahi bug i ka wā e hana ana me Excel 2013.  

Download loulou Nā mea hana MZ

Smart Indenter - hoʻokomo maʻalahi i ke code

Hana maikaʻi ʻo ia i kahi hana maʻalahi akā pono loa - hoʻokomo maʻalahi ia i nā ʻaoʻao i ka code VBA, e hōʻike pono ana i nā puka puana, nā loiloi kūlana, etc.

He mea maʻalahi loa ka hāʻawi ʻana i kēia hana i kahi pōkole keyboard kūpono ma ka ʻāpana Koho Indenting a hana me ka pa hookahi.

ʻO ka mea pōʻino, ua haʻalele ka mea kākau o ka papahana i ka makahiki 2005 (no ke aha, Carl!?) A ʻo ka mana hou loa ma ka pūnaewele no Excel 97-2003. Eia naʻe, hana maikaʻi ka polokalamu me nā mana hou. ʻO ka hōʻailona wale nō: inā loaʻa iā ʻoe ka Excel 2013, a laila ma mua o ka hoʻokomo ʻana iā Smart Indenter, pono ʻoe e hoʻokomo i ka mana hou loa o MZ-Tools, no ka mea. aia i loko o ka hale waihona puke e pono ai no ka hana a Indent.

Download loulou Hoʻokomo akamai

Nā mea hana VBE - nā mea hoʻokani micro-tuning i nā ʻano

ʻO ka hoʻoponopono ʻana i nā mana (nā pihi, nā kahua hoʻokomo, nā lepili kikokikona, a me nā mea ʻē aʻe) ma kahi ʻano paʻakikī hiki ke lilo i mea ʻeha i ka hoki. Hoʻopaʻa maʻamau i ka pahu hoʻoponopono ma o ka papa kuhikuhi Mea Paahana — Koho — Nui — Align Controls to Grid ʻAʻole kōkua nui i kekahi manawa a hoʻomaka ʻo ia e hele i ke ala, ʻoi aku inā pono ʻoe e neʻe, no ka laʻana, ʻo ke pihi liʻiliʻi. E kōkua ka VBE Tools add-on i kēia mea, ma hope o ke kau ʻana, e hōʻike i kahi papa maʻalahi kahi e hiki ai iā ʻoe ke hoʻoponopono maikaʻi i ka nui a me ke kūlana ma ke ʻano no ka mea i koho ʻia:

Hiki ke hoʻololi i ke kūlana me nā Alt+arrows, a me ka hoʻololi ʻana me Shift+Alt+arrows a me Ctrl+Alt+arrows.

Eia kekahi, ma ke kaomi ʻana i kahi mea, hiki iā ʻoe ke hoʻololi koke iā ia me ke code.

Download loulou Mea Hana VBE

VBA ʻokoʻa - ʻImi ʻokoʻa ma ke Code

E ʻoi aku ka maikaʻi o kēia hāmeʻa no nā mea papahana VBA ʻoihana i ka wā e hana ana i nā papahana nui a paʻakikī a i ʻole ka hoʻomohala ʻana. ʻO kāna hana nui ka hoʻohālikelike ʻana i ʻelua mau papahana a hōʻike i ka ʻokoʻa o ke code ma waena o lākou:

Aia he 30 mau lā manuahi, a laila e noi ka mea hoʻohui iā ʻoe e uku i 39 paona no ia (e pili ana i 3.5 tausani rubles ma ke kumukūʻai o kēia manawa).

ʻO ka'ōlelo pololei, hiki mai ia i koʻu ola i nā manawa 3-4 wale nō ma nā papahana nui loa, akā ua hoʻopakele iaʻu i nā lā he nui a me ka nui o nā pūnana nerve 🙂 ʻAe, aia mau, ʻoiaʻiʻo, kahi koho manuahi: hoʻoiho i ka code i kahi faila kikokikona (kaomi ʻākau modulo – mea hoʻolilo) a hoʻohālikelike iā lākou ma hope ma Microsoft Word me ka hoʻohana ʻana i ke kauoha Nānā - Hoʻohālikelike i nā Palapala, akā me ke kōkua o VBA Diff he ʻoi aku ka maʻalahi o ka magnitude.

Download loulou VBA ʻokoʻa

Nā Moqups a me ka Wireframe Sketcher - ka hoʻopili prototyping

I ka hana ʻana i nā pilina paʻakikī no ka launa pū ʻana o ka mea hoʻohana, ʻoi aku ka maʻalahi o ka hoʻolālā ʻana i mua o ke ʻano o nā pahu kamaʻilio, ʻo ia hoʻi. ke kākoʻo. ʻOiaʻiʻo, ʻoi aku ka maʻalahi o ka hana hou ʻana i nā palapala i mākaukau a me kā lākou code ma hope. Hoʻomanaʻo wau i hoʻokahi manawa ma kekahi o nā papahana i noi ʻia e ka mea kūʻai aku e hana i kahi "menu", ʻo ia hoʻi "nā papa". ʻO ka hapalua lā o ka hana ma lalo o ke kahawai 🙁

Nui ka nui o nā papahana i uku ʻia a manuahi o nā pae like ʻole o ka paʻakikī a me ka mana no kēia mau hana. Ua ho'āʻo wau ma kahi o nā papahana a me nā lawelawe like, a i kēia manawa ua hoʻohana pinepine wau Nā Moqups:

He mea hoʻoponopono pūnaewele kēia:

• ʻAʻole pono e hoʻokomo i nā polokalamu kaʻawale. Hiki iā ʻoe ke hele mai i ke keʻena o ka mea kūʻai aku a wehe-hōʻike-pololei i ka interface i hana ʻia ma ka pūnaewele.
• Loaʻa nā mea nui a pau o nā pahu kamaʻilio (nā lepili, nā pihi, nā papa inoa, a me nā mea ʻē aʻe) i nā mana no Windows a me Mac.
• Hiki iā ʻoe ke hoʻokuʻu aku i ka interface i hana ʻia ma PNG a i ʻole PDF a hoʻouna i kahi loulou i ka mea kūʻai aku no ka nānā ʻana ma ka pūnaewele.
  
• manuahi maoli. Aia nā palena i ka helu o nā mea kiʻi, akā ʻaʻole hiki iaʻu ke hele ma mua o lākou. Inā pau ʻoe i waho a makemake paha e mālama i nā papahana nui i ka manawa hoʻokahi, hiki iā ʻoe ke hoʻonui mau i ka mana premium no $99 i kēlā me kēia makahiki.

Ma keʻano laulā, no nā hana a kahi mea hoʻomohala ma VBA - ʻoi aku ka nui, manaʻo wau.

Inā makemake kekahi i kahi koho offline (e hana me ka ʻole o ka Internet ma kahakai, no ka laʻana), a laila paipai wau Ueaea Sketcher:

Ma hope o ka manawa demo manuahi no 2 mau pule, e noi ʻo ia iā ʻoe e kūʻai no ka $99 like.

Link i Nā Moqups

Download loulou Ueaea Sketcher

Invisible Basic – code obfuscator

ʻO ka mea pōʻino, ʻaʻole hiki ke laka paʻa i ka code kumu o kāu macros me kahi ʻōlelo huna ma Microsoft Excel. Eia naʻe, aia kahi papa holoʻokoʻa o nā papahana i kapa ʻia mea hoohuoi (Mai ka ʻōlelo Pelekania. obfuscate - huikau, huikau), ka mea e hoʻololi i ke ʻano o ke code VBA ma ke ʻano he paʻakikī loa ka heluhelu a hoʻomaopopo ʻana, ʻo ia hoʻi:

• Ua hoʻololi ʻia nā inoa o nā mea hoʻololi, nā kaʻina hana a me nā hana me nā pūʻulu ʻano lōʻihi ʻole a i ʻole, me nā inoa pōkole hiki ʻole ke hoʻomaopopo ʻia.
  
• wehe ʻia nā indent hōʻike ʻike
• wehe ʻia a i ʻole, hoʻonoho ʻia nā hoʻomaha laina, etc.

ʻOiaʻiʻo, ʻaʻole wau makemake i ka hoʻohana ʻana i kēia mau ala. ʻO ka mea nui, me PLEX, ua hoʻoholo wau e ʻoi aku ka maikaʻi o ka hāʻawi ʻana i nā mea kūʻai aku i ka mana piha i wehe ʻia, hoʻomaopopo a ʻōlelo ʻia ke kumu kumu - ʻoi aku ka pololei o kēia. Eia nō naʻe, ua loaʻa pinepine koʻu mau hoa polokalamu polokalamu i nā hihia i ka wā e pono ai ka polokalamu (ua hana ka programmer i ka hana, akā ʻaʻole i uku ka mea kūʻai aku, etc.) No laila inā pono ʻoe, e ʻike i kahi e loaʻa ai. "He poʻe maluhia mākou, akā ʻo kā mākou kaʻa kaua ..." a me nā mea āpau.

Download Kumu ʻike ʻole

Code Cleaner – hoʻomaʻemaʻe code

Ma ke kaʻina o ka hana ʻana i kahi papahana (ʻoi aku ka nui a me ka lōʻihi), hoʻomaka ka "ʻōpala" e hōʻiliʻili i nā modules code a me nā ʻano - nā ʻōpala o ka ʻike lawelawe hoʻoponopono VBE e hiki ke alakaʻi i nā glitches i manaʻo ʻole ʻia. Mea hoohana Code Cleaner hoʻomaʻemaʻe i kēia muck ma kahi ala maʻalahi akā hilinaʻi: hoʻokuʻu i ke code mai nā modules i nā faila kikokikona, a laila hoʻihoʻi maʻemaʻe. Manaʻo nui wau i ka wā e hana ai i nā papahana nui, e hana i kēlā me kēia "hoʻomaʻemaʻe".

Download loulou Code Cleaner

Līpika XML Lunahooponopono

Inā makemake ʻoe e hana i kāu ʻaoʻao ponoʻī me nā pihi nani ma ka lipine Excel e holo i kāu macros, a laila ʻaʻole hiki iā ʻoe ke hana me ka ʻole o ka hoʻoponopono file XML interface. ʻOiaʻiʻo, ʻo ka mea maʻalahi a ikaika i kēia lā ʻo ka papahana home ma kēia ʻano. Līpika XML Lunahooponoponoi hana ʻia e Maxim Novikov.

He polokalamu maikaʻi loa ia:

• e ʻae iā ʻoe e hoʻohui maʻalahi i kāu mau ʻāpana, nā pihi, nā papa inoa hāʻule iho a me nā mea ʻē aʻe o ke kikowaena Office hou i ka lipine.
• kākoʻo piha i ka ʻōlelo
• kōkua i ka hoʻoponopono ʻana ma ka hōʻike ʻana i nā ʻōlelo aʻoaʻo
• hiki ke maʻalahi i nā haʻawina
  
• piha loa

Download loulou Līpika XML Lunahooponopono

PS

No nā makahiki he nui, ua nānā ʻole ʻo Microsoft i nā mea hoʻomohala VBA, me ka noʻonoʻo ʻana he ʻōlelo haʻahaʻa haʻahaʻa. Ua paheʻe nā lono i kēlā me kēia manawa ʻaʻole e loaʻa iā Visual Basic ka mana hou o Office a i ʻole e pani ʻia e JavaScript. Hoʻopuka pinepine ʻia nā mana hou o Visual Studio me nā mea maikaʻi hou, a ua paʻa ka mea hoʻoponopono VBE i ka makahiki 1997, ʻaʻole hiki ke hoʻokomo i ke code me nā mea hana maʻamau.

ʻO ka ʻoiaʻiʻo, ke mālama nei nā tausani o ka poʻe i nā hola a me nā lā e hoʻomaikaʻi ana i nā mea polokalamu VBA e hana ana i nā macros e hoʻomaʻamaʻa i nā hana maʻamau i kēlā me kēia lā. ʻO ka mea i ʻike i ka hoʻouna ʻana o kahi macro ma nā laina 10 code i nā faila i nā mea kūʻai aku 200 i ka hapalua minuke, e hoʻololi ana i ʻekolu mau hola o ka hana naʻaupō, e hoʻomaopopo iaʻu 🙂

A oi aku. 

ʻO nā papahana a pau ma luna nei kaʻu koho pilikino a me ka ʻōlelo pilikino e pili ana i ka ʻike pilikino. ʻAʻohe o nā mea kākau i noi mai iaʻu no ka hoʻolaha ʻana a ʻaʻole i uku no ia (a ʻaʻole wau e lawe, ma ke kumu). Inā loaʻa iā ʻoe kahi mea e hoʻohui ai i ka papa inoa ma luna - aloha i nā manaʻo, ʻaʻole e noho mau ke kanaka mahalo.