ActiveX

To save a portion of the sheet to XML data in a buffer

Use the ExportRangeToXMLBuffer method, and set the parameters as follows:

1. If you have multiple sheets, specify the Sheet first.
2. Set the Col, Row, Col2, and Row2 parameters to specify the cell, row, column, or block of cells to export.
   Using Column and Row Properties explains valid values for the Col, Row, Col2, and Row2 parameters.
3. Set the Root parameter to specify the root element to use in the XML data.
4. Set the Collection parameter to specify the collection element to use in the XML data.
5. Set the Flags parameter to specify whether to save formatted or unformatted data.
6. Set the LogFile parameter to the path and file name of the log file you want the control to create.
   If you do not want to generate a log file, set the LogFile parameter to "".