Using FileDialog to export to Excel

[zapouk]

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 are not supported in Microsoft Access."
So how do you do it? Sure this is a common question and there's a work-around somewhere...

Thanks.​

 

[pr2-eugin]

Could you provide the code snippet?

 

[ghudson]

Maybe this sample will help you... Browse [Find a directory or file]