Analyze it with MS Excel to specific folder

[Guest]

Whenever you click on "Analyze it with MS Excel" after running a query, the
records are saved into an Excel file with the same query name and
automatically opens MS Excel. When this happens, the location of the said
file varies.

Is there a way to specify to which folder the file should be saved?

The current setup is fine. I run the query to check the records and then if
need be, I click on "Analyze it with MS Excel" and further check on the
records using MS Excel. I just wish that there is a way to have the resulting
file saved in one location in my hard-disk and not look all over for where
these files are stored.

 

[Alex Dybenko]

Hi,
you can run docmd.OutputTo for example and specify file name

 

[Guest]

Thanks for the input. The command does partly what I wanted. What I was
hoping to do is to open the query first and view the records - and then
decide to export the records onto Excel by Clicking on the "Analyze it with
MS Excel" button, but I want it done by having the file saved in one specific
location; sort of customizing the "Analyze it with MS Excel" button in way.

 

[Van T. Dinh]

I am not sure but in my case, the Excel file goes to the same folder (My
Documents) every time. This is my Default Database folder as set in the
Tools / Options... / General tab.

OTOH, once you have the Excel spreadsheet opened, you can simply use
(Excel's) File /
Save As ...and save another copy in you nominated folder. I guess you need
to go through your directory structure and delete the unwanted copies of the
Excel files occasionally in this case.