Date:         Tue, 15 Jun 1999 14:16:15 +0200
Reply-To:     Hanna Zaremba <h.zaremba@CBOS.PL>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:         Hanna Zaremba <h.zaremba@CBOS.PL>
Subject:      PD:      Re: PIV. TABLE TO WORD SAVING SPSS-format
Comments: To: "listserv@listserv.uga.edu" <SPSSX-L@listserv.uga.edu>
Content-Type: text/plain; charset="iso-8859-2"

Gail
Thanks a lot for quick respons, it  is very useful, but  it is not exactly
what I need .
Probably, I expres my problem not enought precisely.
 I dont wont to paste the SPSS pivot tables as pictures,  I need to export
them as a
Tables (thay mast be tables in Word, other people will edit them).
They even need not to be exactly the same as in SPSS, but only similar.
 
 
I am working on a Word Macro to obtain from the tables after transmisiom  by
The Export_To_Word_RTF.sbs script tables similar  as I have in SPSS , but it
is still unsucceded.
My tables are quite complicated  and i am new in Word Macros as well as in
screept.
 
Any  sugestion would be greatly appreciated!  Thank you.
 
 
Hanna Zaremba CBOS, Poland
 
 
-----Wiadomość orginalna-----
Od: Lucas, Gail <glucas@SPSS.COM>
Grupy dyskusyjne: bit.listserv.spssx-l
Do: SPSSX-L@UGA.CC.UGA.EDU <SPSSX-L@UGA.CC.UGA.EDU>
Data: 14 czerwca 1999 16:26
Temat: Re: PIV. TABLE TO WORD SAVING SPSS-format
 
 
>Hanna,
>
>Here is a technical note that I think addresses your problem.  If you
modify
>the Export to Word script, it will paste the SPSS pivot tables as pictures,
>and will look exactly like what you see in SPSS.
>
>Gail
>SPSS Technical Support.
>
>Q.
>I am using SPSS 7.5 or above, and copy-and-paste to get SPSS Pivot Tables
>into Microsoft Word.  The script Export_To_Word_RTF.sbs on the SPSS Script
>eXchange at http://www.spss.com/software/spss/scriptexchange/export.htm
><http://www.spss.com/software/spss/scriptexchange/export.htm> pastes tables
>as text.
>
>Is there a way to automatically export Pivot Tables to Word as pictures?
>
>
>A.
>Yes.  The Export_To_Word_RTF.sbs script contains the code to do this, in
the
>form of comments.  There are also comments which give instructions on how
to
>edit the script so that it will paste pictures.
>
>Find the following block of text in the script.
>(Hint: Choose ExportItems from the drop-down list of procedures, then
scroll
>down a little.)
>Follow the instructions.
>
>
>  '******************************************************
>  'uncomment the following line if pasting as a picture
>  'PasteIntoWord objItem, "Pict"
>  '******************************************************
>  'comment out the remainder of this case if pasting as picture
>  PasteIntoWord objItem, "RTF"
>  'apply a Word Macro to format the table
>  WordMacro intFootnotes
>  '******************************************************
>
>
>When you're finished, it will look like this:
>
>
>  '******************************************************
>  'uncomment the following line if pasting as a picture
>  PasteIntoWord objItem, "Pict"
>  '******************************************************
>  'comment out the remainder of this case if pasting as picture
>  'PasteIntoWord objItem, "RTF"
>  'apply a Word Macro to format the table
>  'WordMacro intFootnotes
>  '******************************************************
>
>
>The script will now paste pictures instead of RTF text.  Save it with a
>different name, such as Export_To_Word_Pict.sbs.
>
>
>[Optional] If you wish, you may discard the following subroutines, since
>they will no longer be used:
>
> WordMacro
> FindWordTable95
> FindWordTable97
> ConvertToTextAndBackAgain
>
>They are all found together, near the beginning of the script.
>
>-----Original Message-----
>From: Hanna Zaremba [mailto:h.zaremba@CBOS.PL]
>Sent: Monday, June 14, 1999 3:08 AM
>To: SPSSX-L@UGA.CC.UGA.EDU
>Subject: PIV. TABLE TO WORD SAVING SPSS-format
>
>
>
>Hello all,
>
>   I mast send many tables to further edition in Word (in Edition
Department
>they does
>not use SPSS). I am trying to export tables to Word, using
>