Yuav ua li cas qhib Excel tshiab hauv lub qhov rais cais

Koj puas tau tos ob peb feeb rau koj phau ntawv ua haujlwm Excel kom khiav macro, hloov kho Power Query, lossis rov xam cov qauv hnyav? Koj tuaj yeem, tau kawg, sau lub sijhawm ncua nrog ib khob tshuaj yej thiab kas fes ntawm qhov chaw raug cai, tab sis tej zaum koj yuav muaj lwm qhov kev xav: vim li cas ho tsis qhib lwm phau ntawv Excel nyob ze thiab ua haujlwm nrog rau tam sim no?

Tab sis nws tsis yooj yim li ntawd.

Yog tias koj qhib ntau cov ntaub ntawv Excel hauv txoj kev ib txwm muaj (ob-nias hauv Explorer lossis ntawm Cov ntaub ntawv – Qhib hauv Excel), lawv cia li qhib tib yam piv txwv ntawm Microsoft Excel. Raws li, yog tias koj khiav ib qho kev suav rov qab los yog macro hauv ib qho ntawm cov ntaub ntawv no, tag nrho daim ntawv thov yuav tsis khoom thiab tag nrho cov ntawv qhib yuav khov, vim tias lawv muaj cov txheej txheem Excel.

Qhov teeb meem no daws tau yooj yim heev - koj yuav tsum pib Excel hauv cov txheej txheem tshiab cais. Nws yuav muaj kev ywj pheej ntawm thawj tus thiab yuav tso cai rau koj ua haujlwm ntawm lwm cov ntaub ntawv hauv kev thaj yeeb thaum yav dhau los piv txwv ntawm Excel ua haujlwm hnyav ua ke. Muaj ntau ntau txoj hauv kev los ua qhov no, qee qhov yuav lossis tsis ua haujlwm nyob ntawm koj lub version ntawm Excel thiab cov hloov tshiab uas koj tau teeb tsa. Yog li sim txhua yam ntawm ib qho.

Txoj kev 1. Frontal

Qhov kev xaiv yooj yim tshaj plaws thiab pom tseeb tshaj plaws yog xaiv los ntawm cov ntawv qhia zaub mov tseem ceeb Pib - Programs - Excel (Pib - Programs - Excel). Hmoov tsis zoo, txoj hauv kev tseem ceeb no tsuas yog ua haujlwm hauv cov laus ntawm Excel.

Txoj Kev 2: Nruab nrab nas khawm lossis Alt

1. Nyem txoj cai los ntawm txhaj rau Excel icon ntawm lub taskbar - cov ntawv qhia zaub mov ntsiab lus yuav qhib nrog cov npe ntawm cov ntaub ntawv tsis ntev los no.
   
2. Hauv qab ntawm cov ntawv qhia zaub mov no yuav muaj kab Excel - nyem rau ntawm nws tshuav nas khawm, tuav thaum tus yuam sij Alt.
   

Lwm Excel yuav tsum pib hauv cov txheej txheem tshiab. Tsis tas li ntawd, es tsis txhob laug-nias nrog Alt Koj tuaj yeem siv tus nas khawm nruab nrab - yog tias koj tus nas muaj nws (los yog lub log siab ua nws lub luag haujlwm).

Txoj kev 3. kab hais kom ua

Xaiv los ntawm cov ntawv qhia zaub mov tseem ceeb Pib - Khiav (Pib - Khiav) los yog nias lub keyboard shortcut Yeej+R. Hauv daim teb uas tshwm sim, sau cov lus txib:

Tom qab txhaj rau OK Ib qho piv txwv tshiab ntawm Excel yuav tsum pib nyob rau hauv ib qho kev sib cais.

Txoj kev 4. Macro

Qhov kev xaiv no yog qhov nyuaj me ntsis dua li yav dhau los, tab sis ua haujlwm hauv ib qho version ntawm Excel raws li kuv cov kev soj ntsuam:

1. Qhib Visual Basic Editor ntawm ib lub tab Tus tsim tawm - Visual Basic (Tus tsim tawm - Visual Basic) los yog keyboard shortcut Alt + F11. Yog tabs tsim tawm tsis pom, koj tuaj yeem tso nws los ntawm Cov ntaub ntawv – Kev xaiv – Ribbon teeb (Cov ntaub ntawv - Kev xaiv - Customize Ribbon).
2. Hauv Visual Basic qhov rais, ntxig ib qho tshiab khoob module rau cov cai los ntawm cov ntawv qhia zaub mov Ntxig - Module.
3. Luam cov cai hauv qab no rau hauv:

Sub Run_New_Excel() Set NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = True End Sub  

Yog tias koj khiav tam sim no tsim macro ntawm Tus tsim tawm - Macros (Tus tsim tawm - Macro) los yog keyboard shortcut Alt+F8, ces ib qho piv txwv ntawm Excel yuav raug tsim, raws li peb xav tau.

Txhawm rau kom yooj yim, cov cai saum toj no tuaj yeem muab ntxiv tsis yog rau phau ntawv tam sim no, tab sis rau Tus Kheej Phau Ntawv ntawm Macros thiab muab lub pob cais rau cov txheej txheem no ntawm lub vaj huam sib luag nkag ceev - ces qhov no yuav nyob ntawm tes.

Txoj Kev 5: VBScript file

Txoj kev no zoo ib yam li yav dhau los, tab sis siv VBScript, ib qho yooj yim heev version ntawm Visual Basic lus, ua tej yam yooj yim txoj cai nyob rau hauv lub qhov rais. Txhawm rau siv nws ua cov hauv qab no:

Ua ntej, pab kom cov zaub ntawm extensions rau cov ntaub ntawv hauv Explorer mus txog Saib – File Extensions (Saib - File Extensions):

Tom qab ntawd peb tsim cov ntawv sau rau hauv ib lub nplaub tshev lossis ntawm lub desktop (piv txwv li NewExcel.txt) thiab luam cov VBScript code hauv qab no muaj:

Set NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = True set NewExcel = Tsis muaj dab tsi  

Txuag thiab kaw cov ntaub ntawv, thiab tom qab ntawd hloov nws qhov txuas ntxiv los ntawm txt on vbs. Tom qab renaming, ceeb toom yuav tshwm sim uas koj yuav tsum pom zoo, thiab lub icon ntawm cov ntaub ntawv yuav hloov:

Txhua yam. Tam sim no ob-nias lub pob laug nas ntawm cov ntaub ntawv no yuav tso tawm ib qho kev ywj pheej tshiab ntawm Excel thaum koj xav tau.

PS

Nco ntsoov tias ntxiv rau qhov zoo, khiav ntau zaus ntawm Excel muaj nws qhov tsis zoo thiab. cov txheej txheem no "tsis pom" ib leeg. Piv txwv li, koj yuav tsis tuaj yeem ua qhov sib txuas ncaj qha ntawm cov ntawv ua haujlwm hauv Excel sib txawv. Tsis tas li ntawd, kev theej ntawm qhov sib txawv ntawm qhov kev zov me nyuam, thiab lwm yam yuav raug txwv hnyav heev. Feem ntau, txawm li cas los xij, qhov no tsis yog tus nqi loj los them rau tsis nkim sijhawm tos.

• Yuav ua li cas txo cov ntaub ntawv loj thiab ceev nws
  
• Phau Ntawv Tus Kheej Macro yog dab tsi thiab siv nws li cas