My excel becomes empty after _Excel_BookClose() and _Excel_Close()

[ashly]

Hi, i'm trying to read a range of value of my excel files and it works with _Excel_RangeRead().

After that, there'are _Excel_BookClose() and _Excel_Close() to close the file.

However, now the file is empty when i double-click to open it, but i still can read the value by my AutoIt program.

Is it possible to restore my excel files? And why would it be like this?

[water]

Can you please post your script?

I guess it is a problem with setting the workbook to invisible.

[ashly]

U'r right!

I try to set the $bVisible parameter to True then the problem is solved.

Thank you so much!

[water]

[caramen]

 

Is it possible to restore my excel files? And why would it be like this?

 

Always work on copy to tryout things