Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Powerpoint Presentation via Excel VBA code
I have an excel macro in which I would like to open a powerpoint presentation
based upon a selection made in a drop-down box. The code I have so far is below, I just don't know how to tell excel how to open the presentation. Thanks. Private Sub Business_Plan_Change() Workbooks.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Powerpoint Presentation via Excel VBA code
It looks as though the code you have below is trying to open a PPT file in
Excel. From what you've written, I don't think that's what you actually want to do. To open a PPT presentation by running code in Excel, you need to do four things - add a reference to the powerpoint object model, boot powerpoint, make powerpoint visible, and then open the file you want. To add the reference: Open VBE (Alt F11) Tools / References Scan down for "Microsoft Powerpoint <version Object Library" Check the box Click OK Once you've added the reference, the following code should do what you want: Private Sub Business_Plan_Change() Dim PPT As PowerPoint.Application Set PPT = New PowerPoint.Application PPT.Visible = True PPT.Presentations.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub Hope that helps. - Andy Tischaefer Test Lead, Microsoft Office This posting is provided as is, and confers no rights. "hurlbut777" wrote in message ... I have an excel macro in which I would like to open a powerpoint presentation based upon a selection made in a drop-down box. The code I have so far is below, I just don't know how to tell excel how to open the presentation. Thanks. Private Sub Business_Plan_Change() Workbooks.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Powerpoint Presentation via Excel VBA code
When I follow the prescribed instructions, I get a run-time error
'-2147467259 (80004005)'; PowerPoint could not open the file "Andy Tischaefer [MSFT]" wrote: It looks as though the code you have below is trying to open a PPT file in Excel. From what you've written, I don't think that's what you actually want to do. To open a PPT presentation by running code in Excel, you need to do four things - add a reference to the powerpoint object model, boot powerpoint, make powerpoint visible, and then open the file you want. To add the reference: Open VBE (Alt F11) Tools / References Scan down for "Microsoft Powerpoint <version Object Library" Check the box Click OK Once you've added the reference, the following code should do what you want: Private Sub Business_Plan_Change() Dim PPT As PowerPoint.Application Set PPT = New PowerPoint.Application PPT.Visible = True PPT.Presentations.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub Hope that helps. - Andy Tischaefer Test Lead, Microsoft Office This posting is provided as is, and confers no rights. "hurlbut777" wrote in message ... I have an excel macro in which I would like to open a powerpoint presentation based upon a selection made in a drop-down box. The code I have so far is below, I just don't know how to tell excel how to open the presentation. Thanks. Private Sub Business_Plan_Change() Workbooks.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Powerpoint Presentation via Excel VBA code
That error indicates that the path you're providing to your powerpoint file
is not valid. To debug, you might try: dim filepath as string filepath = "F:\Reports\" & Business_Plan.Value & ".ppt" and then verify that filepath is what you expect to be, and that it is pointing to a valid file. Hope that helps. - Andy Tischaefer Test Lead, Microsoft Office This posting is provided as is, and confers no rights. "hurlbut777" wrote in message ... When I follow the prescribed instructions, I get a run-time error '-2147467259 (80004005)'; PowerPoint could not open the file "Andy Tischaefer [MSFT]" wrote: It looks as though the code you have below is trying to open a PPT file in Excel. From what you've written, I don't think that's what you actually want to do. To open a PPT presentation by running code in Excel, you need to do four things - add a reference to the powerpoint object model, boot powerpoint, make powerpoint visible, and then open the file you want. To add the reference: Open VBE (Alt F11) Tools / References Scan down for "Microsoft Powerpoint <version Object Library" Check the box Click OK Once you've added the reference, the following code should do what you want: Private Sub Business_Plan_Change() Dim PPT As PowerPoint.Application Set PPT = New PowerPoint.Application PPT.Visible = True PPT.Presentations.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub Hope that helps. - Andy Tischaefer Test Lead, Microsoft Office This posting is provided as is, and confers no rights. "hurlbut777" wrote in message ... I have an excel macro in which I would like to open a powerpoint presentation based upon a selection made in a drop-down box. The code I have so far is below, I just don't know how to tell excel how to open the presentation. Thanks. Private Sub Business_Plan_Change() Workbooks.Open Filename:="F:\Reports\" & Business_Plan.Value & ".ppt" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel problem with editing in a PowerPoint Presentation | Excel Discussion (Misc queries) | |||
can I merge data from Excel document into PowerPoint presentation | Excel Discussion (Misc queries) | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Worksheet Functions | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Discussion (Misc queries) | |||
Creating a powerpoint presentation from MS-Excel | Excel Programming |