Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Unable to Insert linked text object in Powerpoint 2010

Posted on 2013-06-21
8
Medium Priority
?
879 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 1500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A lot of things can happen during a presentation, worst of which is “death by PowerPoint.” Here are a few mistakes to avoid to make your slides clean.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

636 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