Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB Script to launch powerpoint presentation

Posted on 2009-04-02
2
Medium Priority
?
1,059 Views
Last Modified: 2012-08-13
I ceated the follwing scrip to launch a powerpoint presentation for our marketing display workstations on startup by placing this script file into the startup group.  The problem is that the file name migh change so i was thinking of using the follwoing line for line 3 of the code Set Pres = PPT.Presentations.Open("C:\Test\*.ppt") but this fails.  Is there a way to run this sayingopen only the ppt presentation in the specifed folder.  We will only have one presentation in the folder at a time.
Set PPT = CreateObject("PowerPoint.Application")
PPT.Visible=True
Set Pres = PPT.Presentations.Open("C:\Test\Test.ppt")

Open in new window

0
Comment
Question by:georgedschneider
2 Comments
 
LVL 8

Assisted Solution

by:jwarnken
jwarnken earned 1000 total points
ID: 24050427
This will work as long as there is only one ppt file in the folder
Dim fso, presFiles
presFolder = "C:\Test"
Set fso = CreateObject("Scripting.FileSystemObject")
Set presFiles = fso.GetFolder(presFolder)
For Each f In presFiles.Files 
	If Right(LCase(f.Name),3) = "ppt"Then presFile = f.Path
Next 
WScript.Echo presFile

Open in new window

0
 

Accepted Solution

by:
georgedschneider earned 0 total points
ID: 24054903
I added your script wiht the one i had previosuly to create the script below making it a little bit more dynamic by reading all fiels fin a folder for the one powerpoint presentation that needs to run.
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set PPT = CreateObject("PowerPoint.Application")
objStartFolder = "C:\Test"
Set objFolder = objFSO.GetFolder(objStartFolder)
Set colFiles = objFolder.Files
For Each objFile in colFiles
	If objfile.type = "Microsoft PowerPoint Presentation" then
	PPT.Visible=True
	Set Pres = PPT.Presentations.Open("C:\Test\Test.ppt")
	End If	
Next

Open in new window

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome, welcome!  If you are new to the series and haven't been following along, please take a brief moment to review the first three installments: Part 1 (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/A_266-VBScri…
This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question