RunSavedImportExport Collections

DCrake

Remembered
Local time
Today, 04:36
Joined
Jun 8, 2005
Messages
8,626
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom