Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1368
  • Last Modified:

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

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
rleyba828
Asked:
rleyba828
  • 2
1 Solution
 
Robert SchuttSoftware EngineerCommented:
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
 
Robert SchuttSoftware EngineerCommented:
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
 
rleyba828Author Commented:
Hi Robert,

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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now