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.
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.