Excel Writer and Multiple Workbooks

[qualtrics]

I need to create several workbooks and save them all in a folder. I am new to this to all I have now is a single workbook coming out of the foreach loop.
how can and produce and save a workbook for each "name"?

foreach ($names as $nombres)
{
$workbook_name=$nombres.'.xls';
$headernames=array();
$workbook = new Spreadsheet_Excel_Writer();
$data=$name[0];
// sending HTTP headers
$workbook->send($workbook_name);
$questiontext =& $workbook->addFormat( array('bold'=>1));
$questiontext->setTextWrap();
$worksheet =& $workbook->addWorksheet();
$worksheet->write(0,0, $nombres);
$headers=mysql_query("select distinct names from db where ".getStrings($nombres))
or die(mysql_error());
while ($row3 = mysql_fetch_row($headers)){
$headernames[]=$row3[0];}
$countheaders = count($headernames);
$j=1;
foreach($headernames as $header)
{
$worksheet->write(0,$j, $header);
$j++;
}
foreach ($code as $qs)
{
$worksheet->setColumn(0,0,45);

$worksheet->write(1+$qs, 0, $question[$qs], $questiontext);
}
$workbook->close();
}

[mark]

Your code isn't easily readable (please use the [code] environment here in the forum), but it looks right. Are you sure that $nombres isn't always the same value, causing the file to be overwritten in each step of the loop?