Hi UtterrAccess members. Long time lurker, first time poster, so first let me say thank you to all in the forums that have unknowingly provided enormous assistance to me over the past few years on a myriad of topics.

Alas, the time has come when I am finally confronting a problem that has not already been solved by your learned contributors - at least not that I can find!

I am embarking on a project to automate the creation of a PowerPoint presentation based on Access data and that involves inserting image files onto slides based on a user's selection. I have found several examples for taking text from Access tables and inserting that text into PowerPoint slides, and these will go a long way toward helping me with the project. However, the missing step for me is the insertion of an image.

The program flow will be:

• User is presented with a form with a series of topic choices with corresponding tick boxes
• Based on topics selected a number of image files saved in various directories are referenced using their file paths stored in an Access table
• Code will (hopefully!) create slides using a nominated PowerPoint template with the relevant image files inserted

If anyone is able to point me in the right direction I would be most grateful.

Thanks in anticipation.

Hi Abe -

If you search Google there is a wealth of information on the topic yu asked about; here are 2 just to get you started. Good Luck!!

http://www.UtterAccess.com/forum/Create-PowerPoint-slides-t460463.html

http://www.juiceanalytics.com/writing/automated-powerpoint-generation/

Hi Motty,

Many thanks for the reply.

Google has been my friend on this journey but thus far has failed me at the last hurdle: the insertion of the image. Your first link does a great job of creating slides with text but, like many that I've found, doesn't include inserting a graphic.

I do defer to your superior googling skills though as I hadn't found the second link. This looks very interesting and will take me a bit of time to chase all the associated links and options down, but on first glance it also seems to fall short of picture insertion. I'll explore further but I'm not prepared to call it solved yet, but I will update the post if I find anything.

Again, many thanks for your interest and time.

As a guess this code might be close to what you need when doing powerpoint automation and wanting to insert pictures:

http://www.developerfusion.com/thread/2570...int-automation/

I searched google for "powerpoint automation to add images"

HTH,
Mark
RPT Software
http://www.rptsoftware.com
http://www.microsoftaccesstemplate.com

Thanks Mark and Motty.

Perhaps it is not my access skills that need honing but my Google skills. Although more likely both.

Your link, Mark, is exactly what I am after.

As an aside, I did manage to solve my problem via a bit of a dummies light bulb moment: I simply recorded a macro in powerpoint as I inserted an image and then copied over the code with a bit of massaging! Doh!

Again, many thanks for taking the time to reply, and your posts have provided me with some further great ideas and resources for my project.

Hey you are doing powerpoint automation so you are probably already past 90% of the developers out there.
Yes learn to use google you will need it more and more.