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
  #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
  #2  
Old August 17th, 2004, 12:05 AM
Glen Millar
external usenet poster
 
Posts: n/a
Default

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



  #3  
Old August 17th, 2004, 12:10 AM
Kurt
external usenet poster
 
Posts: n/a
Default

Hi Brett,
You definitely have to look at www.take-off.as/datapoint
With that add-on you can automate everything without coding.
Kurt.

"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



  #4  
Old August 17th, 2004, 11:07 PM
Brett Ellingson
external usenet poster
 
Posts: n/a
Default

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

  #5  
Old August 17th, 2004, 11:08 PM
Brett Ellingson
external usenet poster
 
Posts: n/a
Default

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

  #6  
Old August 18th, 2004, 01:22 AM
Glen Millar
external usenet poster
 
Posts: n/a
Default

Brett,

To get a copy of the spreadsheet, within Excel you go: File| Save copy As|
and then select name and location. Make sure the extension doesn't default
to ppt but to xls. I'm working on 3 like this now. That will save the
entire workbook as a file.

--

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...
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



  #7  
Old August 19th, 2004, 03:57 PM
Brett Ellingson
external usenet poster
 
Posts: n/a
Default

I'm out of my office until monday. I'll try that then and then repost
if that's okay.

I'm pretty sure I've tried that too and it doesn't seem to work for
some reason. It's like the basic functionality of this thing is shut
down for some reason.

2 other things I'm thinking of a 1) I'll call the person who set
this up. Someone else at my job is still in touch with here. and 2) We
might just recreate the powerpoint presentation and figure a way to
put the functionality we're looking for in it when we re-create it.

I'm on my last week of working there too, so we're mostly training
right now anyway. The new guy taking my job wants to figure out a way
to make a part of it more efficienct and thats where these questions
are coming from. Since I'm on my last week it will probably be up to
him to get to a solution that works for him. But I'll still give it a
try next week before I leave.

Thanks much for the postings and the help.

Brett Ellingson.


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

To get a copy of the spreadsheet, within Excel you go: File| Save copy As|
and then select name and location. Make sure the extension doesn't default
to ppt but to xls. I'm working on 3 like this now. That will save the
entire workbook as a file.

--

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...
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

  #8  
Old August 23rd, 2004, 03:31 PM
Brett Ellingson
external usenet poster
 
Posts: n/a
Default

Glen

Hope you had a good weekend....I have tried the things you've
suggested. Is there anything else you can think of?

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

To get a copy of the spreadsheet, within Excel you go: File| Save copy As|
and then select name and location. Make sure the extension doesn't default
to ppt but to xls. I'm working on 3 like this now. That will save the
entire workbook as a file.

--

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...
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

  #9  
Old August 25th, 2004, 12:28 AM
Glen Millar
external usenet poster
 
Posts: n/a
Default

Brett,

I can't think of anything else because as far as I can see, it works g!
What is going wrong? What is the hitch you are running into? Saving the
whole spreadsheet is the same as getting the exported data.

--
Regards,

Glen Millar
Microsoft PPT MVP
http://www.powerpointworkbench.com/
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego CA
http://www.powerpointlive.com


"Brett Ellingson" wrote in message
om...
Glen

Hope you had a good weekend....I have tried the things you've
suggested. Is there anything else you can think of?

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

...
Brett,

To get a copy of the spreadsheet, within Excel you go: File| Save copy

As|
and then select name and location. Make sure the extension doesn't

default
to ppt but to xls. I'm working on 3 like this now. That will save the
entire workbook as a file.

--

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...
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



 




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 07:37 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.