Solved

Dynamically update powerpoint 2010 slides from text files

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
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…

832 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