loading data from Excel into PowerPoint

[JaneB19]

Good morning!

I have the fun task of loading data from an Excel Spreadsheet into a PowerPoint presentation (with as little human intervention as possible), however I'm having problems!

For starters I would like to set the PowerPresentation to a default presentation file. At the moment I have managed to set the type of file to open (.GetOpenFilename("Presentation (*.ppt), *.ppt&quot ) But I would like to change this so that it opens the PowerPresentation that I specify.

Is this possible or would I have to do it another way. The coding I've done is in the Excel Spreadsheet, using a button to activate the process.

One last question! Is it possible to highlight the data on the spreadsheet and create the graphic (pie or bar chart) in PowerPoint?

Thanks

Jane

[PC2]

 

[terzaghi]

Donìt know if the Standard functions of PowerPoint are enought for your problem but you can do this way.

Prepare on the excel that cointains the data the graphics or the prospects you have to put in your PowerPoint.

Once finished, press control-C

in Powerpoint make Paste Special - Paste Link - Microsoft Worksheet Object
You have the data in Powerpoint.

Every Time you change the excel, your powerpoint should change conseguently. If not right-click on the "picture" and click "Update link"

Hope this helps.

A

 

[JaneB19]

Might sound a bit silly, but I've just found out that a lot of the data required is totals and/or query like filters! Can I still do the paste special?

Thanks A

Jane

[PC2]

 

[terzaghi]

I have Office 2000 and I tried with pivot tables, formulas and autofilters and it works fine...

 

[JaneB19]

Thanks for that! That's the same as me. I'm
sure I'll get there eventually . . .



[PC2]