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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |