Import data from powerpoint table

[Viren]

Hi

I'd like to write VBA code that would enable me to import from powerpoint table to excel. I've tried to record a macro to help me get started but to no avail.

Please help.

Thanks

 

[Trevor G]

Welcome to the Forum,

Which version of MS Office are you using? IF 2007 or higher you can't record a macro in PowerPoint (bad mistake from Microsoft). Do you know which slide the table is on?

Here is some code to open PowerPoint from Excel. I am using the Object method to save setting the Reference to PowerPoint is Excel.

If you can supply the extra information then we should be able to help.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> power1()<br><SPAN style="color:#00007F">Dim</SPAN> ppt <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Object</SPAN><br><SPAN style="color:#00007F">Set</SPAN> ppt = CreateObject("PowerPoint.Application")<br><SPAN style="color:#00007F">With</SPAN> ppt<br>    .Visible = <SPAN style="color:#00007F">True</SPAN><br>    .presentations.Open "Path to .ppt"<br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>