>Is there a way to easily produce a Directory Dialog Box to help a user direct where they want to save a file. I have buttons that allows the user to export the active database to an Excel file or an Access file, but I don't readily see a way to produce a Directory Dialog Box to let them pick from a directory tree where they want to save the file. Any thoughts?
If all the systems are recent (eg Win98, or NT SP4, or the system has IE 4.0 or later installed so that SHELL32.DLL is at least at version 4.71), you might consider using the Shell.Application automation object; there's an example in the FAQ of a GETDIR() replacement built around its BrowseForFolder method. There are some extended capabilities available with SHELL32.DLL version 4.72 or 5.0 (only one day left before IE 5 ships).