export to excel change data for a chart

M

mikeprintco

I wish to export data into excel and then display the data as a chart. I
have set up the excel sheet with a chart and if I right click and export all
works fine. I need my users to be able to do this from access using a button.
If I use the docmd.output to an excel format, the file is overwritten and I
loose the chart.
 
Top