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)