 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / September 2006Link from SPSS to PowerPoint
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 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... > Hey Friends, > [quoted text clipped - 15 lines] > Regards, > 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. > 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. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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.... > 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 [quoted text clipped - 5 lines] > 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. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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 > > Hey I don't want to create new chart. > [quoted text clipped - 32 lines] > PPTools: www.pptools.com > ================================================ 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 >Hey Friends, > [quoted text clipped - 15 lines] >Regards, >Hotpars 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.