-----Original Message-----
Hello,
I am trying to create dynamic charts for a power point file in access. Is
there anyone know the code?
Any help will be appreciated!
Melissa
Hi melissa, a possible solution that does not involve any
coding...
1. create query in Access.
2. in database window, select and copy query to clipboard.
3. in excel, use edit|paste special to paste link the
data. This will ensure that this workbook has current data
regardless whether access is open at the same time.
4. in excel create the chart with the formatting that you
require in your powerpoint presentation.
5.select chart and copy to clipboard.
6. in powerpoint, select the slide and then use edit|paste
special to paste link to excel workbook.
Luck
Jonathan
