Exporting Access Report to PowerPoint

[ions]

My Manager wants to export an Acces report to PowerPoint. I have done some reading and suppossedly it is very difficult automate this using VBA.

1) Is there any VBA code out there that does this?

2) If it's not feasible via VBA is there a way to Copy the Current Page (in Preview MODE) into the clipboard? By using Alt + PrntScrn, the MS access interface is captured. I would like to just capture the report itself. Is that possible?

I am trying to make this as easy as possible for my boss. Automation would be preffered but if that's not possible the next easiest method would be much appreciated.

Thanks so much

 

[Uncle Gizmo]

You could use one of the free screen capture utilities like handysnap from wise pixel media. This has the option to select a particular area and then save it in various picture formats and then use import this picture into your PowerPoint presentation.

 

[ions]

Thank Uncle Gizmo

What is the advantage of using this? It sounds like the reverse of the regular process. Usually you would take a screen shot then crop it. Here you crop/select then take a screen shot.

There is no way to just put the report in a clipBoard?

Thanks