Yadda za a bude, gyara, da kuma canza fayilolin XLAM

Fayil ɗin da ke da fayil na XLAM shi ne Fayil- Ƙaƙwalwar Maɓallin Macro-Enabled da ke amfani da shi don ƙara sabon ayyuka zuwa Excel. Hakazalika da sauran fayilolin fayiloli, fayilolin XLAM sun ƙunshi sel da suke rarraba cikin layuka da ginshiƙai waɗanda zasu iya ƙunsar rubutu, dabarar, sigogi, hotuna da sauransu.

Kamar fayiloli na fayilolin XLSM da XLSX na Excel, fayilolin XLAM sune XML- kuma sun adana tare da matsafin ZIP don rage girman girman.

Lura: fayiloli-shigar da Excel wadanda ba su goyi bayan macros ba zasu iya amfani da tsawo na XLL ko XLA.

Yadda za a Bude fayil XLAM

Gargaɗi: Macros a cikin fayil na XLAM na iya ƙunsar lambar mugunta . Yi la'akari sosai a yayin bude fayilolin fayiloli wanda aka samo ta hanyar imel ko sauke daga shafukan yanar gizo da ba ku sani ba. Dubi Lambarmu na Ƙarin Fayil na Fassara don ƙaddamar da ƙarin kariyar fayil don kauce wa kuma me yasa.

Za a iya bude fayilolin XLAM tare da Microsoft Excel 2007 da sabuwar. Siffofin Excel na gaba sun iya bude fayilolin XLAM, ma, amma idan an shigar da Fitarwar Microsoft Compatibility Pack. Ana iya yin wannan ta hanyoyi daban-daban.

Ko wane irin hanya kake bi ta menus na Excel, sakamakon zai kawo maka zuwa Ƙarin Ƙarar inda za ka iya danna Browse ... don ɗaukar fayil na XLAM. Idan an riga an shigar da add-in a cikin wannan taga, zaka iya saka rajistan kusa da sunan don taimakawa.

Na farko shi ne ta hanyar Fayil> Zɓk.> Add-ins> Goge ... button, kuma ɗayan shi ne ta amfani da Developer> Add-Ins menu a saman Excel. Duba wannan Microsoft ta yaya-don koyi yadda za a iya taimaka wa Developer shafin idan ba a taba gani ba.

Tip: Ana amfani da hanyar ƙarshe, ta hanyar Mai Developer shafin, don buɗe bayanin COM ( EXE da DLL ), ta hanyar maɓallin Ƙa'idar COM .

Duk da haka akwai wani zaɓi don bude fayilolin XLAM a Excel shine saka fayil ɗin a babban fayil don Excel don karanta daga lokacin da ta buɗe. Wannan ya zama C: \ Masu amfani [sunan mai amfani] \ AppData \ Roaming \ Microsoft \ AddIns \ .

Lura: Wasu fayilolin XLAM da aka sauke daga intanet suna katange kuma baza a iya amfani da su a cikin Microsoft Excel ba. Danna-dama fayil a Fayil / Windows Explorer kuma zaɓi Properties . A cikin Janar shafin, danna Buɗe don samun cikakken damar yin amfani da shi.

Idan ka ga cewa aikace-aikacen a kan PC ɗinka yayi ƙoƙarin bude fayil na XLAM amma yana da aikace-aikacen da ba daidai ba ko kuma idan kana son samun wani shirin shigarwa na bude XLAM fayiloli, duba yadda Yadda za a Sauya Shirin Tsare don Tsarin Jagoran Bayanan Fassara na Musamman wannan canji a Windows.

Yadda za a canza Fayil XLAM

Babu wani dalili da za a yi amfani da mai canza fayil ɗin don adana fayil na XLAM zuwa tsari daban-daban.

Duba wannan zauren Excel a kan canza XLAM zuwa XLSM idan kuna son yin haka. Ya haɗa da gyaran dukiyar IsAddIn zuwa False .