VBA code to reports to PPT

[JRBond]

I’m sure someone has ask this question but I don’t see it in any of the known threads — my question is I’m trying find VBA process to that allows me to send an already formatted report to power point without doing a screen shot and making it a pdf. I want to be able to manipulate the file in PowerPoint if needed. Please point in the direction that will help solve this challenge— thanks

[ranman256]

not a good method. Access reports have great definition in Access and PDF.
Putting them in PPT would loose definition, IF they actually could be transfered.

PDF is the only good solution, but you could put a link to the PDF in the PPT slide.

[isladogs]

Although Ranman makes a good point, suggest you have a look at this post by user JHB at another forum which works well.
Any clunkiness in the code is due to the OP's own database not the solution by JHB
https://www.access-programmers.co.uk...03&postcount=9

Here is a powerpoint showing charts from Access created by that user:

Report.zip

[ranman256]

I stand corrected. This JHB resolution is pretty darn good.

[isladogs]

Hi Ranman

I think you were right to make the point as when I tried it a few years ago the result were dreadful.
As a result I went over to PDFs for that purpose

However Jorn (JHB) has showed it is indeed possible to do well.
I'm hoping he will create a demo of this at some point.

[ranman256]

It doesnt really use the access reports (my thinking) , instead it uses MsGraph app to build the charts in PPT.
Wonderful.

[isladogs]

True and it works very well. Fast too....