Solved

Unable to Insert linked text object in Powerpoint 2010

Posted on 2013-06-21
8
829 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
  • 4
  • 4
8 Comments
 
LVL 24

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 24

Expert Comment

by:Echo_S
ID: 39268705
I completely understand, but sorry, I don't.
0
 

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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 24

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 24

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now