Loading an XML Document in Excel

After saving an ADO recordset to an XML file on disk (see Hands-On 29-13 earlier in this chapter), you can load it into a desired application and read it as if it were a database. To gain access to the records saved in the XML file, use the Open method of the Recordset object and specify the filename, including its path and the persisted recordset service provider as "Provider=MSPersist." The following hands-on exercise demonstrates how to open a persisted recordset and write its data to an Excel workbook.

Taking Your VBA Programming Skills to the Web

0 0

Post a comment