Switch between Powerpoint and Excel

thefrasers

Board Regular
Joined
Aug 29, 2007
Messages
58
I am currently writing a presentation which involves me switching between PowerPoint slides and an Excel spreadsheet designed to demonstrate. I know how to launch Excel from PowerPoint (by simply attaching a command line to the particular icon), but would like to be able to launch PowerPoint from Excel. Not simply the basic application, but to return to the point in the slideshow where I last left. If I'm lazy, I'm sure I can do this with ALT-TAB but I wonder if there was a neater way to do this? I'm pretty comfortable with VBA, and I know there is a line to launch applications generally, though I'm looking to return to a particular point in a slide show (the slideshow application won't be closed, because I'll simply click on an Excel icon to launch the particular Excel file).

Hope someone can help.
Peter
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Add a button and put this in the button macro

Code:
    AppActivate "Powerpoint Slide Show"
 
Upvote 0
God you guys are quick! Thanks very much (again). Only thing I need to do now is amend PPT so it doesn't reopen an open EXCEL file....
Peter
 
Upvote 0

Forum statistics

Threads
1,214,978
Messages
6,122,547
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top