[Resolved] PHP to disable appl prompts?

[4rxsid]

Hi all,

I'm using php to create/add/edit excel worksheets remotely. I've got admin access to both ends of the process. Right now, when I run the php script from the command line, if the file I was to save already exists...the info msg box pop's up for confirmation/cancelation etc. How can I disable those msg box's?

//Instantiate the spreadsheet component.
$excel = new COM("Excel.sheet") or Die ("Did not connect");

//Open the workbook to use.
$book = $excel->application->Workbooks->Open($pathToReport.$fileToSave) or Die ("Write to Error Log");

//Create a copy of the workbook, so the original workbook will be preserved.
$excel->Application->ActiveWorkbook->SaveAs($pathToBak.$backup);

It's at the "SaveAs" part, that the msg box appears.

Any ideas?

Thanks!

[4rxsid]

ok...i found the answer finally.

$excel->Application->DisplayAlerts = False;
$excel->Application->ActiveWorkbook->SaveAs($pathToBak.$backup);

just set the displayalerts property = false.