Solved

Powerpoint VBA, reading a file and displaying the text on a slide.

Posted on 2013-06-26
3
1,235 Views
Last Modified: 2013-07-01
Hi Team,

   Just need help finishing a snippet of code from here   -->http://www.pptfaq.com/FAQ00913_Use_VBA_to_read_text_from_a_file.htm.   I am using Powerpoint 2010.

  We have a Help Desk Center where we need to display on large screens live stats that are updated by some external scripts.  e.g. files generated would be numbers for  NewIncidents.txt, UrgentTickets.txt, AgedTickets.txt

  I am not a VBA programmer, but based on the example in the link above, how do I make a looping powerpoint presentation that will open 3 text files, as above, assign the contents   to VBA variables and have Powerpoint display them, one variable per slide (say 15 seconds per slide together with some title text on the slide), then at the end of the presentation, VBA will re-read the files again in case they changed, then loop back to the start?

Thanks very much.
0
Comment
Question by:rleyba828
  • 2
3 Comments
 
LVL 35

Expert Comment

by:Robert Schutt
ID: 39285582
I couldn't understand why nobody was answering this, but I was stunned to find out that PowerPoint doesn't have automatic events out of the box.

I thought this would be an ideal way to do what you want: when the slide changes, read the file based on slide index and put the contents in it.

What you need for that is an add-in for example: http://skp.mvps.org/autoevents.htm 

Note that you need to follow the instructions carefully; on lowering macro security (follow the link below the code on the page you posted), on installing the add-in and then you need to enable the events in the new menu it creates under Tools.

Settings may depend on your PPT version as well, I have a pretty old version but it works nice.

Attached is a zip file with the slideshow (already set up for 15 seconds, repeat, kiosk mode) and some example text files.
FileShow.zip
0
 
LVL 35

Accepted Solution

by:
Robert Schutt earned 500 total points
ID: 39289497
I hope you're still interested in this, I discovered a problem with opening the files from the same directory where the .ppt is, you'll probably want to change this anyway but to use the files I included in the zip (regardless of what PowerPoint considers the current directory) you could change this line in Sub ReadAsciiFile:
sFileName = ActivePresentation.Path & "\file" & Index & ".txt"

Open in new window

0
 

Author Comment

by:rleyba828
ID: 39289693
Hi Robert,

   Thanks for this...I followed the steps to modify security settings, and everything is working fine.  Great help.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
Viewers will learn the different options available in the Backstage view in Excel 2013.
This video teaches viewers how to add simple and professional themes to their slides.

785 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