Solved

Unable to Insert linked text object in Powerpoint 2010

Posted on 2013-06-21
8
859 Views
Last Modified: 2013-06-26
Hi Team,  

   This is related to my earlier question here   -->
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Powerpoint/Q_28162455.html#a39267393

   Our intent is to have some automated scripts automatically update simple text files so that a looping Powerpoint shows current information on our Help Desk large display monitors.

  I notice I can only insert MS Excel files and every time I try to insert simple notepad, or wordpad document in Powerpoint via Obvject  --> Insert Object  --> Create from file   --> Browse, then select the text.txt (or any text file)   --> click "Link" ...., it keeps saying "The Server application , source file, or item can't be found, or returned an unknown error.  You may need to reinstall the server application."

  This happens both at home using windows 7 and Powerpoint 2010 and in the office, using  Windows XP and Powerpoint 2010.

  The other problem with using Excel is that once the OLE link embeds the object, the fonts are not the same as the Powerpoint fonts.  so the slide looks terribly off.  I couldn't find a way to have the excel cell "inherit" the text attributes (like shadows and other effects) of the original text on the slide to make it look seamless.

  Any help would be much appreciated.
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
  • 4
  • 4
8 Comments
 
LVL 25

Expert Comment

by:Echo_S
ID: 39267991
I would use something like PowerPoint Merge to do this type of thing. http://www.pptools.com/merge/index.html

That way you're getting the text into your formatted placeholder, not the ugly Excel cells.

You'll have to manually format those cells in Excel to match the text in PPT if you do it via Insert | Object.
0
 

Author Comment

by:rleyba828
ID: 39268693
Thanks Echo_S,    I took a look at it......however, I was looking for something that could be accomplished within VBA alone... a.k.a. something we wouldn't have to buy....  perhaps you know of a free-ware add-in or public macro?

Thanks
0
 
LVL 25

Expert Comment

by:Echo_S
ID: 39268705
I completely understand, but sorry, I don't.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:rleyba828
ID: 39268986
OK, thanks for that.

 I would still need some help with my original question of why I keep getting this error when I link a notepad or wordpad doc in Powerpoint  --> "The Server application , source file, or item can't be found, or returned an unknown error.  You may need to reinstall the server application."
0
 
LVL 25

Accepted Solution

by:
Echo_S earned 500 total points
ID: 39269310
Well, when you get that error, you can often reregister OLE32.DLL and get things going again -- but it's kind of odd to get that with Notepad and Wordpad. Still, worth a try.

Here are instrux. http://www.pptfaq.com/FAQ00236_Can-t_edit_Org_Chart-_Graph-_Excel_-error_msg-_-server_application-_source_file-_or_item_can-t_be_found--.htm

If reregistering ole32.dll doesn't work, be sure to read through the rest to see if anything's relevant.
0
 

Author Comment

by:rleyba828
ID: 39271426
Hi Echo_S,

  Thanks very much for the help.  No joy, I am using windows 7 64 bit, Powerpoint 2010.   None of the recommendations in the link above worked for me.

   What about this.....is there a way in VBA to open a text file.....read the contents....close the file....asssign the contents to a VBA variable and then have Powerpoint 2010 display that variable?

   And then once it reaches the end of the presentation, I can make Powerpoint loop back to the start....open the file again and read the contents (just in case it changed)....and do the thing over again?

Thanks
0
 
LVL 25

Expert Comment

by:Echo_S
ID: 39271452
Sorry, I'm not a coder so I can't answer that with any authority. :-(
0
 

Author Comment

by:rleyba828
ID: 39271620
Perhaps this can help.....just not sure how to put it all together...--> http://www.pptfaq.com/FAQ00913_Use_VBA_to_read_text_from_a_file.htm
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

728 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