Link from SPSS to PowerPoint

[hotpars]

Hey Friends,

--------------> What I am doing now:

1. Export data from SPSS --> Excel
2. Search Specific Data in Excel and Copy to Temp Excel File
3. Copy data from Temp Excel File to PowerPoint Graph db.
4. Update Graph


--------------> What I want to Do:

I want to create any soluting by which I can direcly get data from SPSS
to PowerPoint or can reduce the horrible steps and time which I am
currently taking.

Any suggestions are most welcome.

Regards,
Hotpars

 

[TAJ Simmons]

DataPoint....
Start here....
http://www.presentationpoint.com/

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
http://www.awesomebackgrounds.com
free powerpoint templates, tutorials, hints, tips and more...

 

[hotpars]

Thank you very much for your kind help.

But Actually I want to do a code by my own. Like I want to write some
code in VB.NET or C#.NET by which I can control macro in powerpoint but
want to take data base from SPSS and want to paste into PowerPoint
Graphs db.

Thank you very much again.

 

[hotpars]

Hey I don't want to create new chart.

Actually My Application is like that.

In our company there are several departments . Each departments are
doing some benchmarking. And give all the data to my department.

After that at each month-end they are producing some presentation for
clients to show them results.

But but .... All the templets are in fixed formet which are developed
in other deparhment and reviewd by each depathment.

Each templets containts like 150 slide. and we have totally 25
templets. Which are already developed and is fix for now. But don't
know if someone from other depathment don't like the chart could be
change it easily.

We have all our database in SPSS. We are looking for some tool by which
we can get the data from SPSS and put them into PowerPoint
autometically by few clicks. And can update Graphs in predifined
template without going to PowerPoint.

Hope you understand my problem.

Thank you very much.

Regards....

 

[hotpars]

Yea,

Answers of you question:
1. Template means predifined slildes with full of charts and other
thing regarding to compan's regulation. Which is fixed.
2. Yea I know It's not possible to do presses PowerPoint without
opening it. And I will ofcourse make it invisible.
-------------------------------------

But How can I take data from SPSS to PowerPoint. I know there is way to
use Excel as intermedium but It's not convienint at all.

Ok suppose I did with Excel and PowerPoint and Suppose someone delete
that chart and insert new one then I also have to change the code for
that. As I am calling all the objects by object number from PowerPoint.
Or If there any otherway to do so?

Thank you very much again for your time and afford.

Regards,
Hotpars

 

[Brian Reilly, MVP]

Try searching pptfaq.com for "Naresh Nichani". He's an Access MVP who
wrote some sample code in PPT to get data out of the sample Access
datafile that comes with Access. You should be able to modify those
Queries to point it at SPSS.

Brian Reilly, MVP

 

[Brian Reilly, MVP]

What was I thinking?

I'm doing a project just like this right now for another Market
Research Company. We are doing it from "normal tab reports" and not
from SPSS, but I know about SPSS and could probably adapt code to do
what you want.

If you would like to discuss this in private please drop me an email
at brian sortofat reillyand.com.

I think you can figure your the sortofat to @ change.

Brian Reilly, MVP
www.reillyand.com