how set default directory for tools/analyze w/Excel

[Guest]

Thanks for any help.
I have a database that I often analze with Excel. When I click on
tools/analyze w/Excel, the default directory is My Documents. I would like to
set it to another directory, since I try to save to a directory on the
network, since it is backed-up, but my computer is not. I set to another
directory, and when I closed the query, and reopened up, then analyzed, the
set directory was still set, but when I closed the database, and reopened, it
was set back to My Documents. Is there a way to set this? It's not a big
deal, but I would like to be able to do.
Thanks again.;

 

[Guest]

Hi,
try to set the default database folder under
tools--options--general--default database folder...If you set it to what the
location is you want then ALL actions like export, analyse...should use that
folder as the start folder.
HTH
Good luck