shayne_bates
08-04-2017, 05:28 AM
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?
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?