DaLiMan Posted August 5, 2004 Posted August 5, 2004 Hi there, I have a script wich writes to a .txt script. But I was thinking, why not directly into Excel. I changed the script, but nothing happens anymore. The file stays empty. Can't this be done, or am I forgetting something. Below a piece of my script: Else Global $File = FileOpen("C:\Progra~1\VCG\Files\Templates\VCG.xls", 1) If $file = -1 Then MsgBox(0, "Error", "Unable to open file.") Exit EndIf FileWrite($file, $Clippy1 & @CRLF) FileClose($File) ControlSend($title, "", "", "{PGDN}") Sleep (250) $Endinfo2 = 1 $Aantal2 = $Aantal1 + 1 $Aantal1 = $Aantal2 EndIf Wend He, new smilies....
sugi Posted August 5, 2004 Posted August 5, 2004 XLS-files contain binary data and AutoIt is unable to read or write binary data so the easiest way would be to write the data to a CSV-file and open this file in excel.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now