Solved

Dynamically update powerpoint 2010 slides from text files

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

SendBlaster Pro 4 - Bulk Email Sending Software

SendBlaster 4 Pro - Best Bulk Emailing Sending Software
Automatic Subscribe / Unsubscribe Processing
Great for Newsletters & Mass Mailings
Optional HTML & Text Composition
Integration with Google Features
Built in Spam Score Checking
Free Professional Templates - Feature Packed!

Question has a verified solution.

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

Outlook Free & Paid Tools
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

739 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