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.

 

[Steve Rindsberg]

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.

Have a look here and at the pages above/below it:

Working with MSGraph charts
http://www.pptfaq.com/index.html#name_Working_with_MSGraph_charts

You'd need to automate PPT (open a file or start a new file, add a chart or
find the slide with the chart you want).

You'd then need to work with the MSGraph object model (it's a different
application from PPT). Depending on your needs, you may only need to fill the
datasheet with the data you've pulled from SPSS.

 

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

 

[Steve Rindsberg]

Hey I don't want to create new chart.

Read my reply again then. I mentioned either creating new charts or working
with existing ones.

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

Template could mean anything. Are these Powerpoint PPT files or something
else?

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.

Do you mean that you don't want to have to start PowerPoint manually to do the
update? That's quite possible. You can automate it, and the graphs within a
PPT file, from other Office apps or from VB/C++ etc.

The links I posted in my last reply will give you some idea of what needs to be
done.

Or do you mean that you don't want PowerPoint involved in the process at all?
That's a very different problem.

 

[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