Sunday, 21 July 2013

Difference Between Xla And Xalm AddIns

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.

2 comments:

  1. Is there any kind of work-around for this?

    ReplyDelete
  2. 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.

    ReplyDelete