RunSavedImportExport Collections (1 Viewer)

[DCrake]

I am building a report generator and one of the options for the output is to PDF. I am using a saved import/export to handle this.

The source of the saved export name is held in a table, This is entered by the user, now I want to be able to check whether the name entered into the table matches one of the saved specs BEFORE attempting to run it. I do not want to use error trapping with the On Error GoTo ... method.

Does anyone know how to do this? I would have thought itwould b something similar to using TableDefs or QueryDefs.

 

[Galaxiom]

Microsoft moved the specifications from system tables to a collection in A2007

CurrentProject.ImportExportSpecifications

Loop though the collection and check for a matching Name property.