LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2005)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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

--


Back to: Top of message | Previous page | Main SPSSX-L page