Getting Excel's charting capabilities from Access

V

vince

Hi,
i currently export from Access to Excel in order to leverage Excel's
advanced charting features.

Is there a way to generate those Excel charts directly from Access?

thx

vince
 
D

Debra Dalgleish

In Access, you could use the TransferSpreadsheet method to send the data
to Excel. Then, in your Excel workbook, you could use Workbook_Open code
to create the chart as the file is opened.
 
Top