export to excel change data for a chart



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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads