VBA to output query results to Powerpoint

[Tango]

I have some pre-made powerpoint slides and an Access DB that uses a query to gather the data for the slide. Currently I "hand jam" the query results from the Access report to the Powerpoint chart.

Does anyone know of a better way to output the query results to access? I dont want to make new charts in powerpoint each time. I just want to update exisiting charts with the new data.

 

[spikepl]

This post gives a hint as to how to procede: http://www.access-programmers.co.uk/forums/showthread.php?t=224967

You will need to reference Powerpoint, and get to know the object model in power point to feed the right values into the right spots.

 

[Tango]

Thank you, although I have to point out my own ignorance here. I didn't understand a lick of what that post said. LOL

My skill level with VBA is the low end of moderate but I have zero knowledge or experience with VBA across Office products. I don't suppose you can dumb it down for me a little bit?

Pretty Please...

 

[spikepl]

Data in Office applications are stored/organized in objects. So if you want to transfer data directly, you need to use Office Automation, that allows you to access the objects of a given .PPTX file from Access. If you have little experience in VBA then you either have to embark on quite some learning, or give it up.

But: there are other ways. If you make your chart in Excel, based on an Excel table, then you can import that chart to PowerPoint, and presumably also link to it directly from PowerPoint (simply open an excel object from Power POint. Alternatively, you can simply prepare the chart in Excel and save it as a picture, and paste that in PowerPoint. You can also make charts in Access, but it is a bit of a pain to get the formatting exactly right, so that part is easier done in Excel.

In Excel, you can link a table to an Access table or query, so that your chart updates when you refresh the data. All this requires no coding.

 

[Tango]

Great info, thank you very much. I'll do some toying around with excel as an intermediary and look at some code for object interactions.