Powerpoint Questions - Should be simple

linktoinsanity · 27 Mar 2018 at 11:36

Hi all,

I was wondering if any office gurus on here could help me with an annoying issue. I have a Powerpoint Slideshow running on a (feeble, but operational) NUC based PC, connected to a TV screen, which should be showing one slide and updating links from an Excel spreadsheet periodically. It just needs to sit there and do it, running the powerpoint presentation all the time and updating the links from the spreadsheet in a sharepoint, but it does not do it. I have tried the obvious updating links, I even have a Macro set up, which works if you run it, but cannot run automatically.

Any ideas?

linktoinsanity · 28 Mar 2018 at 11:41

I'm guessing there are no PowerPoint experts on here?

maj · 28 Mar 2018 at 20:03

If you've enabled the security setting to run Macros automatically, would a simple .bat script on a scheduled task not do it?

Code:

start POWERPNT.exe %~dp0Presentation1.pptm

You'd need to tweak the code as necessary if this does what you want as it assumes the .pptm file and .bat file are in same location.

Or have I misunderstood what you're trying to achieve? I thought if macros were enabled to run without prompting then they would automatically start when document was opened.

linktoinsanity · 30 Mar 2018 at 11:52

maj said:
If you've enabled the security setting to run Macros automatically, would a simple .bat script on a scheduled task not do it?

Code:

start POWERPNT.exe %~dp0Presentation1.pptm

You'd need to tweak the code as necessary if this does what you want as it assumes the .pptm file and .bat file are in same location.

Or have I misunderstood what you're trying to achieve? I thought if macros were enabled to run without prompting then they would automatically start when document was opened.

Thanks for your reply, a batch script is what I have done, but the macros don't run in powerpoint unless you use the Powerpoint script, then when you do that it even opens a show as an editable PowerPoint, not starting the show automatically.

I did not write the script exactly as you have though, what does the %~dp0 mean?