Date:         Sun, 11 Sep 2005 20:53:19 -0400
Reply-To:     Raynald Levesque <rlevesque@videotron.ca>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Raynald Levesque <rlevesque@videotron.ca>
Subject:      Re: Script for Exporting Output to Separate Sheets in the Same
              Excel Workbook
In-Reply-To:  <640C628899D48047BA0CF4C1352E1A75014EE458@isex01.isd.sotech.com>
Content-type: text/plain; charset=us-ascii

Hi Kathy,

There is such a script on the SPSS web site:

1. Go to the support page (http://support.spss.com/tech/default.asp )
2. In the left menu, click on "Patches & Utilities"
3. In the left menu, click on "SPSS Utilities".
4. In the right menu, click on "Scripting Libraries"
5. In the right menu, click on "Export"

The 3rd file "Export to Excel (BIFF).SBS" is the one you are looking for.

Cheers!

Raynald Levesque Raynald@spsstools.net
Visit my SPSS site: http://www.spsstools.net



-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Kathy Dykeman
Sent: September 2, 2005 4:42 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Script for Exporting Output to Separate Sheets in the Same
Excel Workbook


Hello all-

I was just checking out Rayland's website to see if there was a macro
that would export individual SPSS output tables to separate worksheets
in a single Excel workbook.  I only found ones that exported to a single
worksheet.

Does anyone know of a macro that will do this?  Thanks!

Kathy

________________________________
Kathy Dykeman
Account Executive
High Technology Practice
Socratic Technologies, Inc.
2505 Mariposa Street
San Francisco, CA 94110-1424 USA
E  kathy.dykeman@sotech.com
W www.sotech.com

--