Connect Office Apps to .NET with "Lite" Web Services
By Luther Miller, November 01, 2003
It's possible to communicate between .NET and older versions of Office with a "lite" web service by using ASP.NET. Luther takes advantage of a class in MSXML called "XMLHTTPRequest," which handles all of the plumbing to make an HTTP request and receive an XML response.
Connect Office Apps to .NET with "Lite" Web Services
Listing 11 Copying the data into Excel
' Loads the results of GetAuthors into the first sheet
Private Sub CommandButton1_Click()
Dim loRecordsets As Collection
Dim lsUrl As String
lsUrl = "http://localhost/LiteWebServicesCS/GetAuthors.asmx"
'get the authors
Set loRecordsets = ConvertXmlDocumentToRecordsetsCollection( _
InvokeLiteWebService(lsUrl))
'copy the authors Recordset into the Excel sheet
Sheet1.Range("A1").CopyFromRecordset loRecordsets(1)
End Sub
