How can I access Excel table from PPT

[Mr. Structure]

Dear anybody,

Would you know how can I access an Excel workbook/sheet/range from a PPT macro?

My objective is to automate my presentations based on various Excel tables.

If this forum is not the right place to ask, please give me a hint where can I find this.

Absolute ideal solution for me would be to have a 2003 PPT Programming Manual.

Thank you for your time.

[mrice]

You need to make a reference to the Excel object model. Do this under Tools -references in the VBA editor. You can then create Excel objects and control them. A useful tip is to record the Excel portions of the a macro initially in Excel and then copy these across to PPT. Prefixing the Excel objects with the Excel object that you have created should get them to work OK.