XML File (frmExportHTMLXMLData) form will open (as shown in Figure 10.26). The form has
From Date and To Date textboxes for specifying a date range; clicking the “Inspect New Jobs to
Export” button loads the subform with the records from the selected date range.FIGURE 10.26
Inspecting the filtered job records to export to an HTML or XML file.Clicking the “Export Jobs to HTML File” button (or “Export Jobs to XML File”; the caption changes
with the selection in the “Export File Type” option group) starts the export. The HTML export is done
with the TransferTextmethod with the acExportHTMLvalue for the TransferTypeargu-
ment; the XML export is done with the ExportXMLmethod of the Access Applicationobject.Figure 10.27 shows an exported HTML file opened in Internet Explorer 7. Unfortunately, it is com-
pletely unformatted and thus probably won’t be very useful.Part II Writing VBA Code to Exchange Data between Office Components