Excel Macro to Start a PowerPoint Presentation

[UHD2017]

So I have an Excel spreadsheet with an embedded PowerPoint presentation, I want to create a Macro that either:

1. Starts playing the presentation in the allocated sized Window as soon as the Excel spreadsheet is opened (if possible)

2. If the above isn't possible then the ability to click on the presentation window so it starts playing.

I'm also wondering if the above can be achieved without embedding the spreadsheet but located in the same folder.

Would appreciate some assistance.

Thank you,

[BellyGas]

Please Login or Register  to view this content.

You can put the above in the 'workbook_open' event.....and it'll run when you open the workbook.

[UHD2017]

Hi,

Thank you, unfortunately when opening the Excel document it doesn't appear to start the presentation.

I placed the above code in to the Workbook_Open Event, do I need to assign a macro to the presentation itself within Excel?

Thank you,

Edit: if I click on the presentation I get a compile error - Invalid outside procedure.

[BellyGas]

What happens if you put the code above in a standard module (surrounded by Sub subname and End Sub) and run it?

eg:

Please Login or Register  to view this content.

[UHD2017]

If I assign a Macro and place the code in there, when I click on the presentation it just launches PowerPoint in a new window with the presentation

[BellyGas]

Doh. i think I may have misunderstood your initial request. You don't want to open a PPT then, you want to have the PPT opened in Excel?

[UHD2017]

Yeah so I would like the embedded Power-point in Excel to start playing the slideshow when Excel is opened, or if that's not possible the ability to click on the power point so it starts playing - but this needs to be within the allocated window, if that makes sense.

The other option is to have the power-point separate (within the same folder as the excel doc) but linked to the Excel document and have it playback that way rather than embedding it completely?

[BellyGas]

I think I finally understand the problem. When you embed a ppt into an Excel sheet you can pick the size it appears on the page, however, when you double click it to show the presentation it'll run full screen in another window.

Being honest, I've never tried to do what you're trying and Google was being particularly obtuse about showing me any results that weren't talking about embedding Excel pages into a ppt. However, I did find this:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=756

[UHD2017]

Hi

Sorry had to leave this for a while due to other commitments.

So I gave the above ago and haven't had much look unfortunately, I've now converted the Powerpoint into a MP4 hoping i'd have more luck but the best I can get is for it to open in a new window which isn't what I need.

I don't suppose you're able to help any further? just need it to play/loop within the designated area (window)

Thank you