Access.2007.VBA.Bibl..

FIGURE 10.17

An exported comma-delimited text file opened in Excel.

The new method of dealing with specs works well with fixed-width exports, at least so

long as you always want to export to the save file name, as I do in the sample code.

The relevant procedures from the form module are listed next. The “Clear Jobs to Export” button’s

event procedure clears the datasheet subform of jobs:

Private Sub cmdClearData_Click()

On Error Resume Next

Me![subFilteredJobs].SourceObject = “”

End Sub

NOTENOTE

Part II Writing VBA Code to Exchange Data between Office Components