Embeding Excel Sheet on PowerPoint Slide

Rizwan khan has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Embeding Excel Sheet on PowerPoint Slide by hdb (Monsignor) on Apr 19, 2013 at 12:45 UTC
Some hints for you to find out how to do it: The function in VBA you are looking for is (most likely) AddOLEObject. In Powerpoint, go to the Developer Ribbon. Start VBA (Alt F11). In VBA, start Object Browser (F2). Type addoleobject in the search field and click the search button. Check the function call and work out how to specify a filename instead of a classname in contrast to pie chart in powerpoint. From here, it might involve a bit of experimentation, but that is the same for me as well...	[reply]
Re: Embeding Excel Sheet on PowerPoint Slide by Old_Gray_Bear (Bishop) on Apr 19, 2013 at 19:48 UTC
What have you tried? How did it fail? What error message(s) did you get? You said in response to your earlier node Pie Chart in Excel "hey...thanx a lot...that really wrokd well for me as expected....Thank You Monk." So....? What is different now? ---- I Go Back to Sleep, Now. OGB	[reply]
Re: Embeding Excel Sheet on PowerPoint Slide by Anonymous Monk on Apr 20, 2013 at 04:01 UTC
If you want to automate anything on win32 you have to absorb the following knowledge . It mostly consists of learing the ole/excel/powerpoint... object model, and using Win32::OLE to call it or sending messages using guitest. OLE is essentially a fancy/standardised way of sending messages. Its very much like web-scraping, you have to know HTTP/HTML DOM .... the rest is just legwork Win32::OLE The behavior of Win32::OLE->new Using Win32::OLE and Excel - Tips and Tricks Automating Windows Applications with Win32::OLE - Perl.com, Automated GUI Testing - Perl.com Re: perl library for controlling Windows GUI (like AutoIt) Re: Write to WIndows Event Log Re: How to get location of Desktop folder on Win32 Read and write Windows "shortcut" links Where is the Win32::OLE Docs Using Win32::GuiTest WinSpy OLESPY Win32::OLE - Type Library Browser http://www.microsoft.com/com/ OLE/COM Object Viewer (oleview.exe) Scriptomatic 2.0 #develop Office Automation with Perl How do I convert a VBA macro to Perl? OLE withevents site:perlmonks.org Excel Object Model Overview href://http://www.roth.net/conference/perl/2000/Perl2000.ppt http://www.roth.net/conference/perl/1999/ole.ppt	[reply]