A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Export data from OLE object in PowerPoint



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 16th, 2004, 11:29 PM
Brett Ellingson
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.