Trouble writing records to excel

[Keval Khichadia]

I am having trouble with one part of a syntax file that is supposed to write (applicants, admits, etc.) information for each specific program (Math, Biology, Humanities) to an existing excel sheet.
There is already an excel sheet that has the information for exisiting majors and when running the spss syntax it wirtes the output for those majors. Recently I had to add Biology to the sheet and I created an extra row in excel for it. When I am run the syntax I am getting an error message [Microsoft] [ODBC Excel Driver] Cannot expand named range and also 'Write request failed - couldn't write any data'.
Any help is appreciated.
Thanks,
Keval

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Peck, Jon]

Several new items have been added to SPSS Developer Central recently.  You can download these at no charge from www.spss.com/devcentral.

Statistical Explorer - A .NET Example
This is a sample application illustrating how to create a .NET application with its own user interface that uses SPSS services invisibly.  It consists of a single form on which you can select a dataset and click on variables to see simple summary statistics and an appropriate chart.  It requires SPSS 16.0.1 or later and the .NET plugin.

The GATHERMD Extension command.
This is an SPSS Extension command that builds a dataset whose cases are the variable names and labels, and, optionally, selected variable custom attributes from one or more files or directories of files.  It can process SPSS, SAS, and Stata datasets.  Extension commands use syntax in the style of standard SPSS commands.  For example,
GATHERMD "c:/spss16/samples".
would search all the SPSS datasets in the specified directory.
GATHERMD can be useful in keeping an inventory of your data if you have many datasets.  It requires SPSS 16.0.1 or later and the Python plugin.  Thanks to Art Kendall for the suggestion.

A True Random Number Generator.
This is a user-contributed Python module that produces truly random rather than pseudorandom numbers by tapping atmospheric noise.  Thanks to George Dunbar for this contribution.  It requires the programmability plugin and SPSS 16.0.1 or later.

We hope that you will find these items useful.

Regards,
Jon Peck
SPSS Inc

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD