If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export data from OLE object in PowerPoint
Hello all,
My main question is: is there a way to export data from an OLE that is an excel spreadsheet from a slide in PowerPoint? Here is a brief description of what we do each week. First we have mechanics do their work and as they work they enter their information through an epic terminal into a mainframe system. At the end of each week, we download that information into an access database. From the access database, the data goes to a more organized format via a query in excel. Next, we update charts in PowerPoint using that excel data as the source data. These PowerPoint charts are used to display the data for people to analyze and make decisions based on. It's a great system but we are trying to make it more efficient. Every week we print out chart packages (ppt files) that have about 64 graphs. We check these each week by hand by checking the source data from the spreadsheets that feed into the PowerPoint slides. The slides have OLE objects in the slides and what we are trying to do is to find a way to export the data from the spreadsheet that comes up whenever you double-click on the chart in PowerPoint. From the reading I've done so far it seems like the only thing that PowerPoint can do is to export the slides as some kind of a picture (jpeg, gif, tiff, etc). Or you can create a web page or a few other things. But nothing that I try seems to work to get the data exported in some format that can be put back into access. The whole point is to first update the ppt file, and then export the data I just updated the ppt file with. Then compare it to the source data on the excel spreadsheet. If this seems redundant it is somewhat, but these charts are one of the main purposes of my existence. Plus the manager of the place I work at and other managers, who work for him, scrutinize these charts. So I make sure to double … triple … and even quadruple check the numbers. But if there is a way to export the data I would only have to run some kind of a query and compare the exported numbers with the source data. The thing with checking the numbers very thoroughly is that it can take up way too much time. So my basic question is this: does anyone know a way to export the data from an embedded OLE object, which is an excel spreadsheet embedded in PowerPoint? Maybe somehow export the data from the data table back into excel or access? If you need more detail or clarification please let me know. Thanks much for any help. Brett |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HUGE Powerpoint; realatively small amount of data | Powerpoint | 2 | October 15th, 2004 05:05 PM | |
How can I set up and export excel data to a certificate? | Quita | General Discussion | 3 | August 10th, 2004 12:46 AM |
Playing an embedded wave object (OLE) | Chris McConnell | General Discussion | 1 | June 29th, 2004 03:12 AM |
Export Data from Subform | John Vinson | Using Forms | 1 | June 21st, 2004 06:10 PM |
Report doesn't print unbound OLE Word object but does print data | Terry | Setting Up & Running Reports | 0 | June 8th, 2004 12:11 AM |