Getting Excel's charting capabilities from Access
 

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

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.

vince wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html