stiv Posted March 30, 2022 Share Posted March 30, 2022 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"]) Link to comment Share on other sites More sharing options...
Developers Jos Posted March 30, 2022 Developers Share Posted March 30, 2022 (edited) 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 stiv 1 SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
Solution water Posted March 30, 2022 Solution Share Posted March 30, 2022 Please re-read the help file for _Excel_RangeWrite. You are using parameters $vValue, $vRange and $bValue the wrong way. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
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