Open a PPT from an URL (sharepoint) in VBS

rdmueller

imagine a script to open a ppt file and export all slides. This script does exactly this: https://github.com/docToolchain/docToolchain/blob/master/scripts/exportPPT.vbs#L44

I would now like to extend it to open a ppt from an office365 share-link and export the slides. But it seems that the Presentations.Open() method does not like URLs:

https://docs.microsoft.com/en-us/office/vba/api/powerpoint.presentations.open

...and the Presentation.FollowHyperlink() opens the presentation, but I don't get a handle to access it:

https://docs.microsoft.com/en-us/office/vba/api/powerpoint.presentation.followhyperlink

any further idea what I could try?

Tim Williams

Presentations.Open() works OK with URL's but you need the correct format of link to get it to work. If you use the SharePoint "copy link" function then it seems to give you a "web view" link not a "download" link.

It may vary according to your setup, but for me a copied link looks like:

https://myCompany.sharepoint.com/:p:/r/sites/Blah/TestLibrary/Presentation.pptx?d=56fabcc31e450arr58513f3b80886427d&csf=1&web=1&e=nQflGa

Removing the :p:/r/ from the URL is enough to be able to open the presentation in PPT

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-24

Comments

0 comments

TOP Ranking

Article

Open a PPT from an URL (sharepoint) in VBS

Open a PPT from an URL (sharepoint) in VBS

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

How to import an asset in swift using Bundle.main.path() in a react-native native module

pump.io port in URL

Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

BigQuery - concatenate ignoring NULL

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

How to remove the extra space from right in a webview?

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

flutter: dropdown item programmatically unselect problem

How to use merge windows unallocated space into Ubuntu using GParted?

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

Nuget add packages gives access denied errors

Svchost high CPU from Microsoft.BingWeather app errors

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

12.04.3--- Dconf Editor won't show com>canonical>unity option

Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

Any way to remove trailing whitespace FOR EDITED lines in Eclipse [for Java]?