Hello all

Is it possible to automate the "analyse with excel" function via a button on a form to export a query or report to excel.

I would use the transfer spreadsheet, but I do not want it to export to a particular location, I just want them to open in excel in a brand new workbook that is not saved anywhere.

Ta in advance for any help.

Regards

Mav.