Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-06-26
3
Medium Priority
?
1,356 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
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 add transitions to their Slideshows and how to set up timing for the transitions.
The viewer will learn how to edit animations within the presentation, incorporate sound, and set everything up with timing.

618 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