[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Dynamically update powerpoint 2010 slides from text files

Posted on 2013-06-20
4
Medium Priority
?
1,766 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 2000 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

Independent Software Vendors: 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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
I came across an unsolved Outlook issue and here is my solution.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

873 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