Sign in to follow this  
Followers 0
konan

How to save a excel file when hide the workbook?

1 post in this topic

#1 ·  Posted (edited)

I'm very sorry to have a mistake, and post a question in this area. Please del this post.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

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<<<<<<<<
Edited by konan

Share this post


Link to post
Share on other sites



Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0