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

Version Compatibility:

Visual Basic 5   Visual Basic 6

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.

This code has been viewed 124421 times.

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.

code/ExcelToXML.zip