Solved

Unable to Insert linked text object in Powerpoint 2010

Posted on 2013-06-21
8
836 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
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)

 
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

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

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
PowerPoint is the go-to presentation software for millions of users around the world. Many presentations use basic text features but you can really make special text jump out of your slide by applying this bubble text design process. This article ha…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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 …

911 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

23 Experts available now in Live!

Get 1:1 Help Now