[Solved] Trouble with Excel UDF and file becoming "invisible"

[keltharak]

Hello,

I had some weird issue with the Excel UDF. I need to replace some value in an excel file. I set de $bVisible parameter of _Excel_Open and _Excel_BookOpen to False to mask windows during the process.

Everything works in my script but after execution, if I try to re-open the file with Excel, the application start but the file is not opened. Of course it works perfectly if I open an other excel file (not modified with my script).

It seems like this issue is related to the $bVisible parameter because if re-open the modified file with Autoit with $bVisible set to False, the file can be open agin with excel. It is like the file keep in memory the last visible state used in Autoit.

Any idea ? Anyone as already faced this issue ?

I use autoit v3.3.14.5.

Thanks and regards

Edited October 1, 2020 by keltharak

[keltharak]

I find a solution, If I set _Excel_Open with  $bVisible=False and _Excel_BookOpen with $bVisible=True it works. 

But if someone can explain me why... ?

[TheXman]

4 hours ago, keltharak said:

I find a solution, If I set _Excel_Open with  $bVisible=False and _Excel_BookOpen with $bVisible=True it works. 

But if someone can explain me why... ?

Why don't you just read the help file entry for _Excel_BookOpen?    It explicitly addresses your question.

Edited September 30, 2020 by TheXman

[keltharak]

Well... I don't know... Sorry. 

Thank you, I feel like an idiot but you answered my question 😅