gspot Posted June 4, 2014 Share Posted June 4, 2014 Hi, I have a code to check if active Excel cell is blank, but doesnt work, i think its because when doing a Ctrl+c in an blank cell (looks blank) it copy's some garbage there... Can you help me, some ideas? Func CopiaExcell() ClipPut("") $sData = "" If Not WinExists("Microsoft Excel", "GSO") Then MsgBox(0, "GSO", "Abra o ficheiro Excel GSO") EndIf WinWait("Microsoft Excel", "GSO") If Not WinActive("Microsoft Excel", "") Then WinActivate("Microsoft Excel", "GSO") Local $oExcel = WinWaitActive("Microsoft Excel", "") Send("{CTRLDOWN}c{CTRLUP}") Sleep(500) Local $sData = ClipGet() MsgBox(0, "", $sData) If $sData <> "" Then MsgBox(0, "", "Non blank") Else MsgBox(0, "", "blank") EndIf EndIf EndFunc ;==>CopiaExcell Link to comment Share on other sites More sharing options...
water Posted June 4, 2014 Share Posted June 4, 2014 I suggest to use the Excel UDF that comes with AutoIt. So you can create code that is fully independant of what the user does. 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...
gspot Posted June 4, 2014 Author Share Posted June 4, 2014 I suggest to use the Excel UDF that comes with AutoIt. So you can create code that is fully independant of what the user does. Ok thanks i got it with _ExcelReadCell. But my doubt now is how to do a kind of _ExcelReadCell for the active cell, without using range. Can this be done? Link to comment Share on other sites More sharing options...
water Posted June 4, 2014 Share Posted June 4, 2014 This should return the active cell: $oExcel.ActiveCell 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