aeolus187

Hi autoit engineer, I always met this when opening excel, it there any way I can recognize the button and click to proceed? Many thanks!

Hi there , I need to auto fill a form in excel creating by VBA code which allow user input some values, the form is read as "ThunderDFrame" for class property, i tried to detect the component like button, dropdown list, checkbox etc, but i cant highlight to the component i want, which mean there is no control ID return as well, any advice how to automate filling for this form? below is what i get from finder tool for detecting Select All button

Thanks Nine, that explains , and per your suggestion, can you hint more for how to create the script on the fly for interact with the form displayed in the macro? much appreciated for your replay!!

Hi Water, the first WinActivate($oWorkbook) is use to focus on Excel and run Macro Then I set the WinWaitActive("OSA Logon Net35") which is passing the title of the window of the form. but the code is stuck at $oExcel_1.run("DoIt") this line

Hi there, I am new to autoit, i have script to run macro in excel, the general process is once macro is run, there will be a pop up form need username/pwd and then process but seems the code is not continue after the script MsgBox() line, do you have any idea how i can auto fill the user id and pwd part? much appreciated! the script is like below: #include <Excel.au3> Local $oExcel_1 = _Excel_Open() Local $sWorkbook = @ScriptDir&"\57799_Generic OSA.xlsm" Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook) WinActivate($oWorkbook) Sleep(3000) $oExcel_1.run("DoIt") WinWaitActive("OSA Logon Net35") ; seems line below this are not executed MsgBox(0,"excel shown","111") ControlSetText("OSA Logon Net35","","[CLASS:WindowsForms10.EDIT.app.0.378734a; Instance:1]","e123456") ControlSetText("OSA Logon Net35","","[CLASS:WindowsForms10.EDIT.app.0.378734a; Instance:2]","e123456") _Excel_Close($oExcel_1,Default,True)