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:   Tue, 6 Sep 2005 11:58:02 +0530
Reply-To:   Parveen Sharma <parveen.sharma@gmail.com>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   Parveen Sharma <parveen.sharma@gmail.com>
Subject:   Re: Script for Exporting Output to Separate Sheets in the Same Excel Workbook
Comments:   To: Kathy Dykeman <kathy.dykeman@sotech.com>
In-Reply-To:   <640C628899D48047BA0CF4C1352E1A75014EE458@isex01.isd.sotech.com>
Content-Type:   text/plain; charset=ISO-8859-1

Hi Kathy,

Please ignore my previous mail. I found some easier code.

Following is the SPSS code for saving data in same excel file but different sheets:

SAVE TRANSLATE /CONNECT='DSN=Excel Files;DBQ=C:\Documents and Settings\Owner\Desktop\tes.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;' /TABLE="mysheet3" /TYPE=ODBC /REPLACE.

...................................................................................................................................... /TABLE="mysheet3" - Data is saved in mysheet3. Change this name to get output in different worksheets.

C:\Documents and Settings\Owner\Desktop\tes.xls - This is the curent path of the output file. ...................................................................................................................................... Found this code at: http://www.spsstools.net/Syntax/Export_Import/ExportDataToSpecifiedSheetOfExistingWorkbook.txt

Regards, Parveen

On 9/3/05, Kathy Dykeman <kathy.dykeman@sotech.com> wrote: > > 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 <http://www.sotech.com> > > -- >

-- __________________________ Parveen Sharma Ph: 9899790674 (Delhi)


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