Geek Answers Handbook

Is there a compatibility issue between macros written for XLS, XLSX, and XLSM?

Is there a compatibility issue between macros written for XLS, XLSX, and XLSM? Will the same macro work for all books?

+5
source share
3 answers

There are significant differences between these formats:

  • .XLSDesigned for use in Excel 2003 and later, so your VBA code must be backward compatible for earlier versions of Excel (<2007)
  • .XLSXis an Excel 2007 format that cannot store VBA code .
  • .XLSM .XLSB - Excel 2007, VBA . , , .

: .XLSB ( .XLS 2007+), .XLSM OOXML.

. xlsm xlsb? .

, , . Ozgrid , Excel 2007. , Excel 2007.

Ozgrid Excel 2007, , , .

+10

. JMax , Excel 2003.

, Excel, . : Excel 2000-2010, Excel 2000.

, , .

, FileSearch ( Excel 2007) Dir.

Excel .

. .

, XLSX . , .

+2

Excel uses Visual Basic for Applications (VBA) for macros. The main difference between the different file types is how the data is stored ( it’s important to edit and it is important that XLSX cannot save macros, formats in XLSM and XLS can save macros in a book). These are excel and VBA that process macros, so it does not create problems between all three file formats.

+1
source

More articles:


All Articles