how to call Excel-chart

[fenglily]

hello
how to call Excel-chart to display some datas from a .mdb file

[jim mcnamara]

A suggestion:

Go into Excel. Turn on recording a macro.

Create the data from the MDB, and then create the chart.

End macro recording.

If you edit the macro, you will find VBA (VB) code that does what you want. You need to cut & paste the code into your project. With a few additional changes, like declaring variables, and creating a ExcelWorksheet object, your VB or VBA app can now do exactly what you want.