S
sulka
Hi there!
Is it possible to copy an existing chart object from Access report page
(Access 2000) to PowerPoint (2000) slide and to do it in VBA?
I have quite lot of reports and would like to automate the process of
exporting them from Access to PowerPoint. I was hoping of being able to
copy at least the "structure" of a chart and then put data from the
recordset, but I can't even do it manually (Edit->Copy from Access,
Edit->Paste to PowerPoint doesn't work). I don't need it to work online,
just simply put chart and data in it, finito, case closed.
Creating a new OLE Object in PPT and having fun setting all the
properties for each chart separately (I don't even know if it is
possible to set _all_ properties by VBA) doesn't really make sense to me
(very "changes sensitive" solution).
Regards,
Is it possible to copy an existing chart object from Access report page
(Access 2000) to PowerPoint (2000) slide and to do it in VBA?
I have quite lot of reports and would like to automate the process of
exporting them from Access to PowerPoint. I was hoping of being able to
copy at least the "structure" of a chart and then put data from the
recordset, but I can't even do it manually (Edit->Copy from Access,
Edit->Paste to PowerPoint doesn't work). I don't need it to work online,
just simply put chart and data in it, finito, case closed.
Creating a new OLE Object in PPT and having fun setting all the
properties for each chart separately (I don't even know if it is
possible to set _all_ properties by VBA) doesn't really make sense to me
(very "changes sensitive" solution).
Regards,