vetold Posted August 19, 2022 Share Posted August 19, 2022 Good afternoon. I am new to AUTOit. Write how to get around this problem? how to register this bypass in ControlClick ? #include <Date.au3> #include <GUIConstants.au3> #include <ExcelCOM_UDF.au3> #include <Excel.au3> Global $Paused HotKeySet("{ESC}", "Terminate") Func Terminate() Exit 0 EndFunc $oExcel = ObjGet("C:\Users\tvois\Desktop\Start\Start.xlsx\", "Excel.Application") ; "схватить" существующий объект Excel $oExcelDoc.Windows(1).Visible = 1 ; Устанавливает первый лист в книге видимым If @error Then MsgBox(4096, "Тест Excel", "Ошибка при получении активного объекта Excel. Код ошибки: " & Hex(@error, 8)) Exit EndIf For $i= 1 To 1000 $sReadCell = _ExcelReadCell($oExcel, "A" & $i) If ProcessExists("chrome.exe") > 0 then MsgBox(0,"Chrome","esiste") Opt("WinTitleMatchMode", -2) WinActivate("Google Chrome") Opt("WinTitleMatchMode", 1) Else MsgBox(0,"Chrome","non esiste") endif MouseClick("left" , 115, 347) Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted August 19, 2022 Moderators Share Posted August 19, 2022 vetold, Welcome to the AutoIt forums. But please do not hijack unrelated threads - just start a new one as I have now done for you. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Subz Posted August 19, 2022 Share Posted August 19, 2022 Look at the _Excel_xxx functions in the helpfile for automating Excel and Webdriver UDF for automating Chrome WebDriver - AutoIt Wiki (autoitscript.com) Link to comment Share on other sites More sharing options...
water Posted August 20, 2022 Share Posted August 20, 2022 The ExcelCOM_UDF (function _ExcelReadCell) is quite old and has been replaced with the Excel UDF. I suggest not to mix this two UDFs. The wiki holds a section describing the Excel UDF and what has changed compared to the old Excel_COM UDF. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - 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