Microsoft Excel yog ib qho cuab yeej siv ntau tshaj qhov uas nws lub npe nrov tsis raug tsis lees paub ntau xyoo. Nws yog ib qho tseem ceeb nyob rau hauv kev tshaj lij thiab ntiag tug lub neej.
Los ntawm kev ntxiv VBA code rau koj cov ntaub ntawv, koj tuaj yeem ua haujlwm ntau yam haujlwm thiab txuag sijhawm ntau.
Cov chav kawm dawb no qhia koj yuav ua li cas thiaj li ua tau lub sijhawm nkag mus. Thiab yuav ua li cas ua kom lub lag luam sai thiab yooj yim li sai tau nrog VBA lus.
Ib qho lus nug xaiv tau yuav tso cai rau koj sim koj cov txuj ci tshiab.
VBA yog dab tsi thiab vim li cas peb siv nws?
VBA (Visual Basic for Applications) yog cov lus programming siv hauv txhua Microsoft Office (tam sim no Microsoft 365) daim ntawv thov (Word, Excel, PowerPoint, thiab Outlook).
Keeb kwm, VBA yog ib qho kev siv ntawm Microsoft's Visual Basic (VB) hom lus pom hauv Microsoft Office daim ntawv thov. Txawm hais tias ob hom lus zoo sib xws, qhov sib txawv tseem ceeb yog cov lus VBA tsuas yog siv tau hauv Microsoft Office daim ntawv thov.
Ua tsaug rau cov lus yooj yooj yim no, koj tuaj yeem tsim ntau lossis tsawg dua cov khoos phis tawj nyuaj uas ua haujlwm rov ua haujlwm dua lossis ua haujlwm ntau yam siv ib qho lus txib.
Hauv lawv daim ntawv yooj yim tshaj plaws, cov kev pabcuam me me no hu ua macros thiab yog cov ntawv sau los ntawm VBA programmers lossis programmed los ntawm tus neeg siv. Lawv tuaj yeem raug tua los ntawm ib qho keyboard lossis nas hais kom ua.
Hauv ntau cov qauv, VBA cov kev pab cuam tuaj yeem ua raws li cov ntawv thov Office tshwj xeeb.
Algorithms tuaj yeem siv los tsim cov ntawv ceeb toom, cov npe cov ntaub ntawv, emails, thiab lwm yam. Koj tuaj yeem siv VBA los tsim cov ntawv thov kev lag luam kom ntxaws raws li cov ntawv thov Office txheem.
Txawm hais tias VBA tam sim no tsis tshua muaj kev txwv rau cov neeg ua haujlwm paub txog, nws txoj kev nkag mus tau yooj yim, kev ua haujlwm nplua nuj thiab kev hloov pauv zoo tseem rov hais dua rau ntau tus kws tshaj lij, tshwj xeeb hauv kev lag luam nyiaj txiag.
Siv lub macro recorder rau koj thawj creation
Txhawm rau tsim macros, koj yuav tsum tau code Visual Basic (VBA) program, uas yog qhov tseeb macro kaw, ncaj qha rau hauv cov cuab yeej muab rau qhov no. Tsis yog txhua tus yog tus kws tshawb fawb hauv computer, yog li ntawm no yog yuav ua li cas teeb tsa macros yam tsis muaj programming lawv.
- Nyem rau ntawm lub tab Tus tsim tawm, ces khawm cov ntaub ntawv ib macro.
- Hauv teb lub npe macro, ntaus lub npe koj xav muab rau koj macro.
Hauv tshav pob Luv tus yuam sij, xaiv ib qho tseem ceeb ua ke ua ib qho shortcut.
Ntaus ib qho lus piav qhia. Yog tias koj muaj ntau tshaj ib qho macro kaw, peb xav kom koj sau lawv txhua tus kom raug kom tsis txhob siv yuam kev.
– Nyem OK.
Ua txhua yam uas koj xav tau los ua haujlwm siv macro.
- Rov qab mus rau lub tab Tus tsim tawm thiab nias rau pob Tso tseg ib zaug koj ua tiav.
Qhov kev ua haujlwm no yog qhov yooj yim, tab sis nws yuav tsum tau npaj qee yam. Cov cuab yeej no luam tag nrho cov kev ua koj ua thaum kaw.
Txhawm rau zam qhov xwm txheej tsis xav tau, koj yuav tsum ua txhua yam tsim nyog rau macro ua haujlwm (piv txwv li, tshem cov ntaub ntawv qub thaum pib ntawm macro) ua ntej koj pib sau.
Puas yog macro txaus ntshai?
Lub macro tsim rau ib daim ntawv Excel los ntawm lwm tus neeg siv tsis ruaj ntseg. Qhov laj thawj yog yooj yim heev. Hackers tuaj yeem tsim cov macro phem los ntawm kev hloov kho VBA code ib ntus. Yog tias tus neeg raug tsim txom qhib cov ntaub ntawv muaj kab mob, Chaw Haujlwm thiab lub khoos phis tawj yuav kis tau. Piv txwv li, cov cai tuaj yeem nkag mus rau hauv daim ntawv thov Office thiab nthuav tawm txhua zaus tsim cov ntaub ntawv tshiab. Qhov phem tshaj plaws, nws tuaj yeem nkag mus rau koj lub thawv xa ntawv thiab xa cov ntawv luam ntawm cov ntaub ntawv tsis zoo rau lwm tus neeg siv.
Kuv yuav tiv thaiv kuv tus kheej li cas los ntawm macro phem?
Macros yog qhov muaj txiaj ntsig zoo, tab sis lawv kuj tseem muaj kev phom sij heev thiab tuaj yeem dhau los ua cov cuab yeej rau hackers los kis malware. Txawm li cas los xij, koj tuaj yeem tiv thaiv koj tus kheej zoo. Ntau lub tuam txhab, suav nrog Microsoft, tau txhim kho lawv daim ntawv thov kev ruaj ntseg ntau xyoo. Xyuas kom tseeb tias qhov no feature yog enabled. Yog tias koj sim qhib cov ntaub ntawv uas muaj macro, software yuav thaiv nws thiab ceeb toom koj.
Cov lus qhia tseem ceeb tshaj plaws kom tsis txhob muaj kev cuam tshuam ntawm hackers yog tsis rub cov ntaub ntawv los ntawm qhov tsis paub. Nws tseem yog ib qho tseem ceeb kom txwv tsis pub qhib cov ntaub ntawv uas muaj macros kom tsuas yog cov ntaub ntawv ntseeg siab tuaj yeem qhib.
Txuas ntxiv nyeem tsab xov xwm ntawm qhov chaw qub →
