Date:         Wed, 27 Jul 2005 12:03:15 -0300
Reply-To:     Hector Maletta <hmaletta@fibertel.com.ar>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Hector Maletta <hmaletta@fibertel.com.ar>
Subject:      Re: Save *.SPO (output) as *.doc or *.rtf using syntax/script
Comments: To: "Rodriguez, Aryelly [LFSGB]" <arodrigu@LFSGB.jnj.com>
In-Reply-To:  <666F35502831A84DA9785CEDFA7817F3055F5131@imlgbinexs1.eu.jnj.com>
Content-Type: text/plain; charset="us-ascii"

Anyelly,
You can read HTM files into Excel or Word, then resave as Word document or
Excel workbook.

Hector

> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]
> On Behalf Of Rodriguez, Aryelly [LFSGB]
> Sent: Wednesday, July 27, 2005 12:02 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Re: Save *.SPO (output) as *.doc or *.rtf using syntax/script
>
> Vishal
>
> Thanks very much for your answer. These scripts kind of solve
> my problem but the final file is a htm, so I need to go to
> the file's final locations and eliminate the .htm from their
> names in order to obtain the desired files
>
> (I think that my main problem is the version of SPSS)
>
> One again many thanks
>
> Kind Regards
>
> Aryelly R.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On
> Behalf Of Vishal Dave
> Sent: 27 July 2005 15:25
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Re: Save *.SPO (output) as *.doc or *.rtf using syntax/script
>
>
> Aryelly,
>
> You have to use script for exporting the files to *.Doc and
> *.Rtf format.  Run the following script for Output file.
>
> ************.Doc:
> Sub Main
> 'To export all visible items of the Designated Output Viewer to XML:
> Call objSpssApp.GetDesignatedOutputDoc.ExportDocument(SpssVisible, _
>         "c:\temp\spssoutput.doc", SpssFormatDoc, False) End Sub
>
> *********.rtf
> Sub Main
> 'To export all visible items of the Designated Output Viewer to XML:
> Call objSpssApp.GetDesignatedOutputDoc.ExportDocument(SpssVisible, _
>         "c:\temp\spssoutput.rtf", SpssFormatRtf, False) End Sub
>
> ************
> You can call the script from syntax by SCRIPT command.  If
> you are saving above scripts as "C:\temp\script1.sbs" and
> "C:\temp\script2.sbs"
> then you can call them in the scripts by command :
>
> *Syntax for output generation comes here* SCRIPT
> "C:\temp\script1.sbs".
> SCRIPT "C:\temp\script2.sbs".
>
> Hope this helps,
> Vishal.
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]
> On Behalf Of Rodriguez, Aryelly [LFSGB]
> Sent: Wednesday, July 27, 2005 9:05 AM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Save *.SPO (output) as *.doc or *.rtf using syntax/script
>
> I wonder if someone could help me. I would like to know if it
> is possible to save SPSS output (*.spo files) as *.doc or
> *.rtf in an automatic way using syntax/script.
> I have followed the recommendations of Mr. Raynald Levesque
> in his website
> (http://www.spsstools.net/)
> but what I have managed to do is to export the output file to
> MS Word or toggle to "Draft Output" before my main
> calculations are performed, in both cases I had to save the
> *.doc / *.rtf files manually .
>
> Kind Regards
>
> PS: Who ever has the kindness to answer my question, would
> like to know that my SPSS is v 10.1.3
>
> > Aryelly Rodriguez
> >
>