Dynamic Powerpoint?

[snoopy75]

Is it possible for a Powerpoint presentation to retrieve data from, say, an Access database when rendering charts and such? I'm lazy; I don't want to have to go in and update the data by hand every week. ;-)

--Ryan

 

[onedtent]

hey, it's an OLE compatible application and has links command under the edit menu. don't see why not.

 

[fneily]

VBA provides a mechanism for talking between two different applications such as PowerPoint and Access. It's called Automation. From a Powerpoint slide, go into VBA (Alt + F11). Reference Access by clicking on Tools then References and place a check next to Microsoft Access 9.0 Library or whatever version you have. Click OK. You can then use code that uses the Access objects and methods to extract data if you want. This is quite a bit of programming. The best thing to do is buy a book on Microsoft Automation.

Neil