How to save a excel file when hide the workbook?

[konan 0]

I open a excel file, but not set it Visible. I del some date, then want to save it. But i find it is not to save without visible.

How can it do it ?

This is my code

$FileName="C:\Test.xls"

$oExcelDoc = ObjGet($FileName)

$oExcelDoc.Worksheets(1).range("A1").Delete

$a1=$oExcelDoc.Worksheets(1).range("A1").value

Msgbox(0,"",$a1);>>>Show the value now

;>>>>>>>>>How to save this Excel file???<<<<<<<<
;>>>>>>>>>Don't activate it<<<<<<<<

[konan 0]

Who can help me?

[DaleHohm 61]

Who can help me?

<{POST_SNAPBACK}>

Here you go:

$FileName="C:\Test.xls"

; Open an Excel Workbook Object
$oExcelWB = ObjGet($FileName) 

; Oddly, even though we will not show the Excel interface in this example
; (with $oExcelWB.Application.Visible = 1), if you don't explicitly make the 
; window object visible before saving the workbook the window will be invisible 
; when you open interactivly
$oExcelWB.Windows(1).Visible = 1 

; Delete the contents of A1
$oExcelWB.Worksheets(1).range("A1").Delete

; Obtain the new A1 value and display in a MsgBox
$a1=$oExcelWB.Worksheets(1).range("A1").value
Msgbox(0,"",$a1);>>>Show the value now

; Save the workbook back to the file and close the workbook
$result = $oExcelWB.Save
$result = $oExcelWB.Close

Exit

Dale

[konan 0]

Thank you very much for your help!