Exporting MS Access 2007 report to powerpoint

rohitsinha
rohitsinha used Ask the Experts™
on
I am trying to export a MS Access Report (graph) into powerpoint. I have a simple code:
* DoCmd.OutputTo acOutputReport, test, acFormatRTF, "c:\rohit.ppt", True this opens a balnk powerpoint file. Tried exporting to word also but the graph does not transfer. Also tried,
* DoCmd.OutputTo acOutputReport, test, acFormatRTF, "c:\rohit.PPTX", True but this gives an error unreadable content in the file.

I do not want to go via snapshot view and will appreciate if some code help
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Sadly, you cannoty "easily" copy Access Charts and paste them into other applications.

The best you may be able to do is output the chart to a Graphic file and paste that into the other app.

An even more convoluted method would be to link the Access data to Excel, then create the chart in Excel, then copy the Excel chart to powerpoint
(But now that I typed it out, it doesn't seem like it is worth the trouble...)
;-)

Let me know if you are interested in the Image approach, I will try to dig up my notes

JeffCoachman

Author

Commented:
Hi Boag,

I can use Screenwriter for selecting the graph and pasting it in powerpoint. Was curious if there was an access solution to the problem.

Thanks though.

Rohit
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<Was curious if there was an access solution to the problem.>
Sorry, not as far as I know.
I wish there was a way as well...
:-(
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
See here too:
http://support.microsoft.com/default.aspx?scid=kb;en-us;200551
<ACC2000: How to Create an MS Graph in PowerPoint Using Access>

Author

Commented:
Couldn't make it work but thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial