Access 2007.
FileDialog for importing is fine - use msoFileDialogFilePicker to pick the full path of the file to import data from.
But when exporting and trying to use FileDialog with msoFileDialogSaveAs it throws an error.
Help says "The msoFileDialogOpen and msoFileDialogSaveAs constants...