Solved

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

Posted on 2013-06-26
3
1,207 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
Comment Utility
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
Comment Utility
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
Comment Utility
Hi Robert,

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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction In all recent versions of PowerPoint it is possible to trigger animations. This means the animation takes place when a certain shape is clicked. This allows you to run animation “on demand” and outwith the normal sequence of mouse cl…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This video teaches viewers how to fit pictures into slides, crop and remove backgrounds, and alter photos to look more professional.
This video teaches viewers how to create handouts from their slides and helps them decide how many slides to include per handout.

762 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now