There is compatibility in old version and new version of VS. We not use micros features
with this extension .Both are Add-In Files. The main difference is that XLAM cannot be opened
in earlier office versions (Pre 2007). And hence when you are creating Add-Ins which has
to be compatible with earlier versions then always create an XLA instead of XLAM. –
Whenever we save the excel sheet, we choose the required extension according enabling micros or
other features.But in case of .xla and .xlam file is not work in MsOffice 2010, let's do for test:-
1) I take a 2010 MS Office and Open excel. 2) Create a micro in excel sheet and save it with .xla extension and other sheet with .xlam. 3) When you open the files the whole worksheet is disable. 4) Because of these extension is uses for earlier version like 2003. They not work in ms office 2010. |
This Blog is belong to Visual Basic For Application(VBA). Here I write excel,outlook, power point programming and explain some feature & properties like Addins, Micros, Modules, Forms, Design etc.
Sunday, 21 July 2013
Difference Between Xla And Xalm AddIns
Subscribe to:
Post Comments (Atom)
Is there any kind of work-around for this?
ReplyDeleteThere is compatibility in old version and new version of VS. We not use micros features
ReplyDeletewith this extension .Both are Add-In Files. The main difference is that XLAM cannot be opened
in earlier office versions (Pre 2007). And hence when you are creating Add-Ins which has
to be compatible with earlier versions then always create an XLA instead of XLAM. –
Whenever we save the excel sheet, we choose the required extension according enabling micros or
other features.But in case of .xla and .xlam file is not work in MsOffice 2010, let's do for test:-
1) I take a 2010 MS Office and Open excel.
2) Create a micro in excel sheet and save it with .xla extension and other sheet with .xlam.
3) When you open the files the whole worksheet is disable.
4) Because of these extension is uses for earlier version like 2003. They not work in ms office 2010.