Abstract
The XML file format was introduced with Excel 2003 (XML support was introduced in Excel 2000). Excel 2007 has new XML file formats. The *.xlsx format represents a workbook that does not and cannot contain macros. The *.xlsm format represents a workbook that can or does contain macros. This separation is a security enhancement that lets the user know in advance of opening a document that there may be code inside. Remember the “This document may contain harmful code” warnings in previous Microsoft Office versions? With these, you would not be aware of the possibility of code until you opened the file. Now, your users will know in advance if they are opening a workbook containing code.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Jim DeMarco
About this chapter
Cite this chapter
(2008). Using XML in Excel 2007. In: Pro Excel 2007 VBA. Apress. https://doi.org/10.1007/978-1-4302-0580-7_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0580-7_3
Publisher Name: Apress
Print ISBN: 978-1-59059-957-0
Online ISBN: 978-1-4302-0580-7
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)