Solved

Dynamically update powerpoint 2010 slides from text files

Posted on 2013-06-20
4
1,630 Views
Last Modified: 2013-06-21
Hi Team,

   We have a small Help Desk team and we want a looping powerpoint presentation that dynamically reads small text files and displays them on different slides.   For example,
Slide 1   --> opencalls.txt
Slide 2  -->  Sev1calls.txt
Slide3  -->  Callsfortheday.txt
 etc.

First, we have scripts that automatically creates these *.txt files and they change all the time.  I tried  embedding the link of the text object to the slides but they don't update when Powerpoint loops back. You have to manually *refresh* the link.

I tried searching in this forum and most relate to linking Excel to Powerpoint.  But our scripts can work only with text.

I am not familiar with VBA (I can learn the basics if required) but would someone have a simple VBA macro that can help me accomplish the task above?

Thanks very much
0
Comment
Question by:rleyba828
  • 2
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
DamjanDemsar earned 500 total points
ID: 39262083
use this plugin to reload linked files on every loop  http://skp.mvps.org/updtlinks.htm
0
 

Author Comment

by:rleyba828
ID: 39262346
Hi DamjanDemsar,

   thanks for this very useful plugin.   Now I am experiencing a side effect.  While I have the Powerpoint in a loop,   I am trying to update a test.csv file (plain text) which is linked to the Powerpoint presentation, now I can no longer update it due to the error  -- "The Process cannot access the file because it is being used by another process".  It seems that the running Powerpoint presentation is locking the test.csv file.

I even tried to create another file called test2.csv and do a copy test2.csv test.csv, and with the same error message.

How do we tell Powerpoint to *open* the file for read only, without locking it?

Thanks very much.
0
 
LVL 5

Expert Comment

by:DamjanDemsar
ID: 39262440
Hmm, I did a test, and it does not happen here.

How did you insert the csv file?

does it happen also without the addin?
0
 

Author Comment

by:rleyba828
ID: 39267393
Hi  DamjanDemsar,

It's working now, thanks.  I tried your solution at home initially, but in the office, I was using XP, a different slide deck, less animations, etc.   Not sure what the issue was, but it's working in my office PC, which is what the target setup is.

Thanks for all your help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
Many programs have tried to outwit PowerPoint in terms of technology and skill. These programs, however, still lack several characteristics that PowerPoint has possessed from the start. Here's why PowerPoint replacements won't entirely work for desi…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

911 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

22 Experts available now in Live!

Get 1:1 Help Now