Consulting

Results 1 to 1 of 1

Thread: ppt to excel

  1. #1

    ppt to excel

    Alright,
    I'm trying to take a powerpoint presentation and bring it into excel. The purpose being to compile all the data and be able to bounce formulas off multiple presentations once they have been pulled over.

    I have pre-determined cells and sheets for the different slides. What I ultimately want is slide one to go to sheet one in a given range, Slide two to go to sheet two, three to three, four to four, five to five, and finally all slides to a compiled sheet 6.

    I have the exact opposite of this project where I can build in excel and export to a ppt presentation but now I want the opposite. Here's what I have so far but I am wholly unfamiliar with VBA commands for ppt slides:

    Option Explicit
    Sub Opposite_Day()
    Dim exlApp As Excel.Application
    Dim exlbook As Excel.Workbook
    Dim exlsheet As Worksheet
    
    Set exlApp = New Excel.Application
    exlApp.Visible = True
    exlApp.Workbooks.Add
    set exlsheet = Sheets.Add
    
    End Sub

    Any solutions on this one?
    Last edited by Paul_Hossler; 08-12-2017 at 07:50 AM. Reason: Added Code tags - use the [#] icon next time

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •