Pehea e wehe ai i kahi Excel hou ma kahi puka aniani

Ua kali paha ʻoe i kekahi mau minuke no ka holo ʻana o kāu puke hana Excel i kahi macro, hōʻano hou i kahi Power Query, a i ʻole e helu hou i nā ʻano koʻikoʻi? Hiki iā ʻoe, ʻoiaʻiʻo, e hoʻopiha i ka pause me ke kīʻaha kī a me ke kofe ma nā kumu kānāwai holoʻokoʻa, akā ua manaʻo paha ʻoe: no ke aha e wehe ʻole ai i kahi puke hana Excel ma kahi kokoke a hana pū me ia i kēia manawa?

Akā ʻaʻole ia maʻalahi.

Inā wehe ʻoe i nā faila Excel ma ke ʻano maʻamau (kaomi pālua ma Explorer a i ʻole ma o ka Waihona – Wehe ma Excel), wehe koke lākou i ka manawa like o Microsoft Excel. No laila, inā e holo ʻoe i kahi helu hou a i ʻole macro ma kekahi o kēia mau faila, a laila e paʻa ka noi holoʻokoʻa a paʻa nā puke hāmama a pau, no ka mea, he kaʻina hana maʻamau ka Excel.

Hoʻopau maʻalahi kēia pilikia - pono ʻoe e hoʻomaka iā Excel i kahi kaʻina kaʻawale hou. E kūʻokoʻa ʻo ia i ka mea mua a e ʻae iā ʻoe e hana i nā faila ʻē aʻe me ka maluhia aʻo ka hana mua o Excel e hana ana i kahi hana koʻikoʻi. Nui nā ala e hana ai i kēia, ʻo kekahi o ia mau hana a ʻaʻole paha ma muli o kāu mana o Excel a me nā mea hou āu i kau ai. No laila e ho'āʻo hoʻokahi i nā mea a pau.

Keʻano 1. Frontal

ʻO ke koho maʻalahi a maopopo loa ke koho mai ka papa kuhikuhi nui Hoʻomaka - Nā polokalamu - Excel (Hoʻomaka - Nā Polokalamu - Excel). ʻO ka mea pōʻino, hana wale kēia ala primitive i nā mana kahiko o Excel.

Ka Papa Hana 2: Pihi kiole waena a i ʻole Alt

1. Bus ka pono ma ke kaomi ʻana i ka ikona Excel ma ka papa hana - e wehe ʻia kahi papa kuhikuhi me kahi papa inoa o nā faila hou.
   
2. Ma ka lalo o kēia papa kuhikuhi e loaʻa kahi laina Excel - kaomi ma luna hema pihi iole, e paa ana oiai ke ki Alt.
   

Pono e hoʻomaka kekahi Excel i kahi kaʻina hana hou. Eia kekahi, ma kahi o ke kaomi hema me Alt hiki iā ʻoe ke hoʻohana i ka pihi ʻiole waena - inā loaʻa i kāu ʻiole (a i ʻole ka huila kaomi i kāna kuleana).

Keʻano 3. Laina kauoha

E koho mai ka papa kuhikuhi nui Hoʻomaka – Holo (Hoʻomaka - Holo) a i ʻole kaomi ʻana i ka pōkole keyboard loaa+R. Ma ke kahua i hōʻike ʻia, e hoʻokomo i ke kauoha:

Ma hope o ke kaomiʻana OK pono e hoʻomaka kahi hana hou o Excel ma kahi kaʻina kaʻawale.

Hana 4. Makro

ʻOi aku ka paʻakikī o kēia koho ma mua o nā mea ma mua, akā hana ma kekahi ʻano o Excel e like me kaʻu mau ʻike:

1. E wehe ana i ka Lunahooponopono Visual Basic ma o ka tab Mea hoʻomohala - Visual Basic (Ka mea hoʻomohala - Visual Basic) a i ʻole ka pōkole papa keyboard Alt + F11. Inā nā tabs mea haku polokalamu ʻaʻole ʻike ʻia, hiki iā ʻoe ke hōʻike ma o Kōnae - Nā koho - Hoʻonohonoho Ribbon (Kōnae — Koho — Hoʻopilikino Ribbon).
2. Ma ka pukaaniani Visual Basic, e hoʻokomo i kahi module hakahaka hou no ke code ma o ka papa kuhikuhi Hoʻokomo - Module.
3. E kope i kēia code ma laila:

Sub Run_New_Excel() Hoʻonoho iā NewExcel = CreateObject("Excel.Application")  

Inā ʻoe e holo i ka macro i hana ʻia i kēia manawa ma o Mea hoʻomohala - Macros (Ka mea hoʻomohala - Macro) a i ʻole ka pōkole papa keyboard Alt+F8, a laila e hana ʻia kahi ʻokoʻa o Excel, e like me kā mākou makemake.

No ka maʻalahi, hiki ke hoʻohui ʻia ke code ma luna nei ʻaʻole i ka puke o kēia manawa, akā i ka Personal Book of Macros a kau i kahi pihi ʻokoʻa no kēia kaʻina hana ma ka papa komo wikiwiki - a laila e paʻa mau kēia hiʻohiʻona.

Hanana 5: faila VBScript

Ua like kēia ʻano me ka mea ma mua, akā hoʻohana ʻo VBScript, kahi mana maʻalahi o ka ʻōlelo Visual Basic, e hana i nā hana maʻalahi ma Windows. No ka hoʻohana ʻana iā ia e hana i kēia:

ʻO ka mea mua, hiki ke hōʻike i nā hoʻonui no nā faila ma Explorer ma Nānā – Hoʻonui Kōnae (Nānā — Hoʻonui Kōnae):

A laila hana mākou i kahi faila kikokikona i loko o kekahi waihona a i ʻole ma ka pākaukau (no ka laʻana NewExcel.txt) a kope i kēia code VBScript ma laila:

E hoʻonoho iā NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = Hoʻonohonoho ʻoiaʻiʻo NewExcel = ʻAʻohe mea  

E mālama a pani i ka faila, a laila hoʻololi i kona hoʻonui mai txt on vbs. Ma hope o ka hoʻololi ʻana, e ʻike ʻia kahi ʻōlelo aʻo e pono ai ʻoe e ʻae, a e hoʻololi ke kiʻi o ka faila:

ʻO nā mea a pau. I kēia manawa e kaomi ʻelua i ka pihi ʻiole hema ma kēia faila e hoʻomaka i kahi hiʻohiʻona kūʻokoʻa hou o Excel inā pono ʻoe.

PS

E hoʻomanaʻo i ka hoʻohui ʻana i nā pōmaikaʻi, ʻo ka holo ʻana i nā manawa he nui o Excel he mau mea ʻino pū kekahi. ʻO kēia mau kaʻina hana "ʻaʻoleʻike" kekahi i kekahi. No ka laʻana, ʻaʻole hiki iā ʻoe ke hana i kahi loulou pololei ma waena o nā pūnāwai puke hana ma Excel ʻokoʻa. Eia kekahi, e kaupalena ʻia ke kope ʻana ma waena o nā ʻano like ʻole o ka papahana, etc. I ka hapanui o nā hihia, akā naʻe, ʻaʻole kēia he kumukūʻai nui e uku no ka pau ʻole o ka manawa kali.

• Pehea e hoʻemi ai i ka nui o ka faila a me ka wikiwiki
  
• He aha ka Personal Macro Book a pehea e hoʻohana ai