G
greg
I have a few questions on excel 2007 vs 2003.
I only have 2003. So if I check application.version I have 11.0.
Is 2007 12?
How can you tell what version an excel doc is? Just by extension? Or
something else?
Is there ways that a 2007 document could be saved as 2003 document with its
2007 extension? Or viceversa?
http://technet.microsoft.com/en-us/library/cc179191(TechNet.10).aspx
So there seems to be 2 extensions for 2007 excel documents?
Office Excel 2007 XML workbook
..xlsx
The default Office Excel 2007 file format. Cannot store VBA macro code or
Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).
and
Office Excel 2007 XML macro-enabled workbook
..xlsm
Uses the same basic XML format as the Office Excel 2007 XML Workbook, but
can store VBA macro code. Users saving an Office Excel 2007 XML workbook
that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are
prompted to use this file format.
so do you automatically get the xlsm if you have macros in the workbook?
Does it flip automatically?
I only have 2003. So if I check application.version I have 11.0.
Is 2007 12?
How can you tell what version an excel doc is? Just by extension? Or
something else?
Is there ways that a 2007 document could be saved as 2003 document with its
2007 extension? Or viceversa?
http://technet.microsoft.com/en-us/library/cc179191(TechNet.10).aspx
So there seems to be 2 extensions for 2007 excel documents?
Office Excel 2007 XML workbook
..xlsx
The default Office Excel 2007 file format. Cannot store VBA macro code or
Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).
and
Office Excel 2007 XML macro-enabled workbook
..xlsm
Uses the same basic XML format as the Office Excel 2007 XML Workbook, but
can store VBA macro code. Users saving an Office Excel 2007 XML workbook
that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are
prompted to use this file format.
so do you automatically get the xlsm if you have macros in the workbook?
Does it flip automatically?