M
mpfohl
I want to create a button to export a query to an excel file.
Ideally, I'd like to just prompt the user for a name and location for
the exported file, but I'm not sure how easy that will be. I don't
want to force the user to type in the file path name, i'd rather them
go through the folders/subfolders with the normal dialog box.
So failing that, I'd settle for the excel file simply being saved to
the same directory the database lives in. However, as this database
will be used as a template and shared, that directory will change.
Thus, I would need to first find the location of the database, and then
set that as the export location. I think I may have to use the
GetOption("Default Database Directory") method, but not sure how to do
it.
Any ideas on how to pull this off?
Thanks
Ideally, I'd like to just prompt the user for a name and location for
the exported file, but I'm not sure how easy that will be. I don't
want to force the user to type in the file path name, i'd rather them
go through the folders/subfolders with the normal dialog box.
So failing that, I'd settle for the excel file simply being saved to
the same directory the database lives in. However, as this database
will be used as a template and shared, that directory will change.
Thus, I would need to first find the location of the database, and then
set that as the export location. I think I may have to use the
GetOption("Default Database Directory") method, but not sure how to do
it.
Any ideas on how to pull this off?
Thanks