Solved

Unable to Insert linked text object in Powerpoint 2010

Posted on 2013-06-21
8
843 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This article will show you how to use shortcut menus in the Access run-time environment.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
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.

839 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