Glen,

Thanks for the response. I've tried to respond all day but have had
trouble posting my reply to your reply.

I actually do want the code for this but I thought I'd get it to work
by using the mouse first then I can write the code for it afterward.

I can open the OLE object without a problem, but the problem seems to
be trying to export the data.

When I open the OLE object, it brings up a MS excel spreadsheet with
just a chart and a single spreadsheet. If I right click at different
places on the chart it will let me format the data or an axis or
change the source data. Those all work fine.

So then I think, "hey, I can make a copy of the spreadsheet to a new
book." So I right click on the tab of the spreadsheet, select ‘move or
copy'. I can make a copy of the spreadsheet right there on the screen
right next to the previous spreadsheet, but in the choice where it
says "To book:" there is not the usual choice of ‘(new book)'.

At this point I'm pretty much stuck

"Glen Millar" glen @ powerpointworkbench.com wrote in message ...
Brett,

Breifly, you can right click on a chart ole object, select Chart Object from
the menu, and "Open". This will open the chart in the original application
(Excel) and allow you to save a copy of the file.

But it seems to me you are in need of some sort of automation? VBA?

--

Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Please tell us your ppt version, and get back to us here
Remove spaces from signature
Posted to news://msnews.microsoft.com

"Brett Ellingson" wrote in message
om...
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