Convert Excel spread sheet to an XML document.

Category:
Office/VBA
Type:
Applications
Difficulty:
Intermediate
Author:
Scott Woods

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
This code demonstrates how to convert EXCEL spread sheets to an XML document. This sample uses ADO 2.5 or Higher. It demonstrates how to connect to an Excel spreadsheet using ADO and how to the save method of an ADO recordset to persist it to an XML file.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download exceltoxml.zip