Yuav Paub
- Ib daim ntawv XLAM yog Excel Macro-Enabled Add-In file.
- Qhib ib qho nrog Excel, dhau ntawm Add-ins qhov rai.
- Hloov nws mus rau XLSM cov ntaub ntawv los ntawm kev kho nws cov cai.
Kab lus no piav qhia tias cov ntaub ntawv XLAM yog dab tsi, suav nrog yuav ua li cas qhib ib qho thiab koj cov kev xaiv yog dab tsi rau hloov ib qho mus rau lwm hom.
XLAM File yog dab tsi?
A cov ntaub ntawv nrog XLAM cov ntaub ntawv txuas ntxiv yog Excel Macro-Enabled Add-In cov ntaub ntawv uas tau siv los ntxiv cov haujlwm tshiab rau Excel. Zoo li Excel's XLSM thiab XLSX cov ntaub ntawv tawm tswv yim, cov ntaub ntawv ntxiv no yog XML-raws li thiab tau txais kev cawmdim nrog ZIP compression kom txo tau qhov loj tag nrho.
Excel Add-In cov ntaub ntawv uas tsis txhawb macros yuav siv XLL lossis XLA cov ntaub ntawv txuas ntxiv.
Yuav qhib cov ntaub ntawv XLAM li cas
XLAM cov ntaub ntawv tuaj yeem qhib nrog Microsoft Excel 2007 thiab tshiab dua. Yav dhau los versions ntawm Excel tuaj yeem qhib ib yam nkaus, tab sis tsuas yog tias Microsoft Office Compatibility Pack raug teeb tsa.
Macros hauv cov ntaub ntawv XLAM yuav muaj cov lej tsis zoo. Ua tib zoo saib thaum qhib cov ntawv ua tiav tau txais los ntawm email lossis rub tawm los ntawm cov vev xaib uas koj tsis paub.
Muaj ob txoj hauv kev qhib cov ntaub ntawv:
Qhib cov ntaub ntawv XLAM Los ntawm Excel's Menu
-
Ib txoj kev uas koj qhib tau yog los ntawm File > xaiv > Ntxiv-ins > Go khawm.
Lwm txoj kev yog Developer > Ntxiv-Ins. Saib Microsoft yuav ua li cas-los kawm paub yuav ua li cas qhib lub Developer tab yog tias koj tsis tau pom nws.
Image Cov txheej txheem tom kawg, dhau ntawm Developer tab, kuj tseem siv los qhib COM Add-Ins (EXE thiab DLL cov ntaub ntawv).
-
Txawm koj mus txoj kev twg, qhov tshwm sim yuav coj koj mus rau Add-Ins qhov rai uas koj tuaj yeem xaiv Browse txhawm rau thauj khoom cov ntaub ntawv.
Image Yog tias koj qhov add-in twb tau teev nyob rau hauv lub qhov rais no, cia li muab ib daim tshev ntawm ib sab ntawm lub npe kom pab tau nws.
Copy cov ntaub ntawv XLAM rau AddIns Folder
Lwm txoj kev qhib cov ntaub ntawv uas muaj txiaj ntsig tshwj xeeb yog tias koj muaj ntau tshaj ib qho, yog muab tso rau hauv daim nplaub tshev no kom Excel yuav cia li thauj nws thaum nws qhib:
C:\Users\[username]\AppData\Roaming\Microsoft\AddIns\
Qee cov ntaub ntawv XLAM uas rub tawm hauv Is Taws Nem raug thaiv thiab tsis tuaj yeem siv tag nrho hauv Excel. Right-click cov ntaub ntawv hauv Explorer thiab xaiv Properties. Hauv General tab, xaiv Unblock kom muaj kev nkag mus rau nws.
How to convert ib XLAM File
Yuav tsum tsis txhob muaj laj thawj los siv cov ntaub ntawv hloov pauv kom txuag cov ntaub ntawv mus rau lwm hom ntawv. Thaum cov cuab yeej ua haujlwm rau ntau hom ntaub ntawv, qhov no tsis yog ib qho ntawm lawv.
Saib lub rooj sab laj Excel no ntawm kev hloov XLAM rau XLSM yog tias koj xav ua qhov ntawd. Nws koom nrog kho cov cuab yeej IsAddIn rau False.
Tseem qhib tsis tau?
Yog tias koj cov ntaub ntawv tsis qhib rau lub sijhawm no, nws muaj feem ntau koj yuav tsis cuam tshuam nrog cov ntaub ntawv XLAM tiag. Qhov no yuav yog rooj plaub yog tias koj tau nyeem tsis raug cov ntaub ntawv txuas ntxiv, uas feem ntau tshwm sim thaum cov ntawv zoo sib xws.
Piv txwv li, XAML tuaj yeem yooj yim tsis meej pem rau XLAM txawm tias cov ntaub ntawv no tau siv nrog lwm txoj haujlwm. AML thiab LXA yog qee qhov lwm tus, qhov twg hom ntawv yog ACPI Tshuab Lus lossis Arc Macro Language (rau yav dhau los), lossis Microsoft Speech Lexicon (tom kawg).
Yog tias koj muaj teeb meem nrhiav seb yuav ua li cas, tshawb xyuas cov ntaub ntawv txuas ntxiv ntawm qhov kawg ntawm koj cov ntaub ntawv kom paub ntau ntxiv txog hom ntawv nws yuav nyob hauv thiab nrhiav kev txuas mus rau software koj xav qhib / kho / hloov nws.
