View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel is not closing

San,
Yes, but from your code, there is no ActiveWindow as there is no workbook.
Unless you missed half of your code.
Probably best asked in a PHP NG.

NickHK

"San" wrote in message
...
Thanks for the replay.

$workbook-close();
$excel_app-Quit();
these two statements are already used before closing.

"NickHK" wrote:

san,
I don't know PHP well, but I assume that is the same as this VB code:
Dim XLApp as Object
Set XLApp=CreateObject("Excel.Application")
XLApp.ActiveWindow.FreezePanes = True

However, is there actually any window yet as you have not added/opened

any
workbooks ?
Check the value of ActiveWindow.

Not sure, but if the application or window is not visible, it may error.

NickHK

"San" wrote in message
...
Hai all,
Im tryiing to access Excel object like following from PHP, scripting
language.
After calling this excel is not closing after the execution.
If we comment the 'FreezePanes' property its working file.

$excel_app = new COM("Excel.Application");
$excel_app-ActiveWindow-FreezePanes = True;

thanks in advance,
San.