Export Query to Excel command code HELP

[Kaylen]

I have some queries which I want to allow the users to be able to export to
Excel and also automatically allow them to save to desired destination (not
the default destination). For example when the user select the parameters
for the query and click OK, the query ran and the Access spreadsheet appears.
I would like to have a program code that when the user click OK, the query
automatically export to Excel and also asked the user to where they want to
save the excel spreadhseet instead of saving to the default folder. Can
someone help me with the code? Where do I place this command code?

 

[Piet Linden]

I have some queries which I want to allow the users to be able to export to
Excel and also automatically allow them to save to desired destination (not
the default destination).  For example when the user select the parameters
for the query and click OK, the query ran and the Access spreadsheet appears.
I would like to have a program code that when the user click OK, the query
automatically export to Excel and also asked the user to where they want to
save the excel spreadhseet instead of saving to the default folder.  Can
someone help me with the code? Where do I place this command code?

TransferSpreadsheet is your friend.
You can pass whatever path you want to it, which will save the file
where you specify.
If you want to specify a location, you can use the OpenSaveFile API on
Access web. www.mvps.org/access

 

[Ken Snell \(MVP\)]

See various code examples on this website:
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm