Import Data to Excel but Keep Chart Format

  • Thread starter Thread starter DM - NPS
  • Start date Start date
D

DM - NPS

I have 2 queries in Access and I want to import the data from those queries
into an Excel file (called Charts.xls). Each query and related chart will be
on a different worksheet of the Excel Workbook.

I tries using the do.cmd OutputTo option (tied to a command button) which
allowed me to transfer the data to Excel but when I run the command it
deletes the Chart already setup in the Excel file.

As an end result what I want is for a person to click the command button and
it opens the excel file and displays the most up-to-date data and a bar char
associated to the data.

Any Ideas? Thanks in for the help.
 
DM-NPS,

I wouldn't try to send the chart but the data and then have the Excel
workbook open to the chart.
 
Back
Top