I need to be able to import the data from the tables in PowerPoint into an excel table that I have built. Each slide has the content for 1 row of data in the excel table, but the Powerpoint table is formatted with the 'column headers' as column 1, and the data in column 2. I would like the macro to run in the powerpoint and open the excel ItemListTemplate file and add the data to the 'Item List' Sheet. I have found a couple macros that would export the tables themselves or create a csv that could be imported, but again because the format is columns to rows in stead of rows to columns I can't figure it out. Please Help!
Bookmarks