button to export query?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi,

I've got the following situation:

A user needs to export a certain real-time list of data from his Access
2003 database as an Excel file. I've got the query and I know how to
export the query manually. But I need to have a button that the user
simply has to click to get asked where he wants to save (fixed location
is okay too) his XLS file. The app is running in runtime mode.

Is that possible and how do I do that?

Thanks a lot!

Jerome
 
Thanks, I don't really need the 'select a file name' option. It can
simply be the name of the query or some other hard-coded name.

I'll looking into the TRansferSpreadsheet function!
 
Back
Top