Filewrite

[DaLiMan 0]

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 0]

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.

[DaLiMan 0]

Thanx, gonna try it thattaway