Excel formula example - (Moved)

[stiv]

Hello fellow Autoit.

I have a problem, which consists of establishing in the code Autoit, the excel formula that I want in a column "C" in this case, convert everything that is in the column into an established date format in order to copy it.

this is what i try

Thank you very much for your attention

Global $oExcel = _Excel_Open()

 Global $oWorkbook = _Excel_BookOpen($oExcel, "C:\ejemplo.xlsx")

$Formula="=TEXTO(C2;"AAAA,DD-MM-YYYY")"

 _Excel_RangeWrite($oWorkbook,$vWorksheet, $vValue[, $vRange = $Formula,"C"])

 

 

[Jos]

Moved to the appropriate forum.

This is now the fourth one we had to move for you, so please simply post in the Support forum when you have an Autoit3 question... can't really be that hard now can it?   

Moderation Team

Edited March 30, 2022 by Jos

[water]

Please re-read the help file for _Excel_RangeWrite. You are using parameters $vValue, $vRange and $bValue the wrong way.