Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Macros in MS Access to Ms Powerpoint

by jhel013 Jul 6, 2009 1:10AM PDT

Hi, I'm new in Macros and currently reading some basic tutorials in VBA. My problem is, I need to automate a presentation from MS Access. So here it goes..

The data will be from MS Access which contains monthly tables and there will be a Macro in MS Powerpoint. What I want to do is there will be a button in MS Powerpoint that contains a list of Months from the MS Access and when I choose one, automatically it will create a graphical presentation. I hope you get the idea?

..so that I won't manually create presentations every month.

My knowledge are shattered that's why I need help how to start connecting MS Access to MS Powerpoint and how to make it automated.

I'm really pressured right now and any idea will help.

Thank you.