Solved

Dynamically update powerpoint 2010 slides from text files

Posted on 2013-06-20
4
1,681 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
[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
  • 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

Technology Partners: 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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

691 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