Well I was trying to achieve this copy data from excel file without opening excel file... or may be open in background closed after pasting.. XlApp := ComObjActive("Excel.Application") newestFile := XlApp.Range("au4").Value ; full file path. xl := ComObjGet(newestFile) var := "N" var1 := xl.Applicat...

Thank you | Bravo , AlphaBravo Following code worked and I understand how to create array with coordinates xl := ComObjActive("Excel.Application") xl.Sheets("Detail").Select var := "N" var1 := xl.Application.WorksheetFunction.CountIf(xl.Range("W:W"), var) + 15 var2 := "Totals" var3 := xl.Application...

OR MAY BE ; read example " MyComObj.SomeMethod("abc",, 123) " ;expression .SomeMethod(Param1, Param2, Param3, Param4) ;expression A variable that represents an Application object. oWorkbook := ComObjGet(newestFile) var = "N" FoundA := oWorkbook.Application.WorksheetFunction.CountIf(.Sheets("Detail")...

I want to use excel worksheet function though ahk, here is vba code Sheets("Sheet2").Select var = "N" var1 = Application.WorksheetFunction.CountIf(Range("W:W"), var) + 6 var2 = "Totals" var3 = Application.WorksheetFunction.MATCH( var2,Range("c:c"),0) + 15 MsgBox var1 MsgBox var3 End With but I don't...

while not ready { Try { element_id = ctl00_ContentPlaceHolder2_ucFormEDocumentRequest_FormEDocumentInformationUC_ddlDischargePort if (wb.document.getElementById(element_id).getelementsByTagName("option").length > 0) Ready := true } sleep 100 } Thank You so much :superhappy: its worked....... :salut...

well while loading dropdown last following image saying "loading please wait shows in center of webpage" here is html <input type="image" name="ctl00$upBar$ImageButton1" id="ctl00_upBar_ImageButton1" src="../../Images/Loading.gif" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBac...

try something like this wb.document.getElementById("UC_ddlCountry").value := 840 wb.document.getElementById("UC_ddlCountry").onchange() element_id = ctl00_ContentPlaceHolder2_ucFormEDocumentRequest_FormEDocumentInformationUC_ddlDischargePort while (wb.getElementById(element_id).getelementsByTagName...

at times i have been able to use the busy state to wait for Ajex callbacks to be done but hey let's try something else what does the html of the ports dropdown look like before you input a country is it there, is it blank or what please try and post the html of the ports dropdown before it's ready ...

Try something like this while wb.busy Sleep 100 Thank you :wave: I am trying.....! I tried..... wb.busy didn't worked, neither wb.onload, as I described its element that start loading... :( How I suppose to used "window.onload" or obj.onload or may be "object.onload = handler;" issue is page do not...

here is drop down list of country <select name="ctl00$ContentPlaceHolder2$ucFormEDocumentRequest$FormEDocumentInformationUC$ddlCountry" onchange="javascript:setTimeout('__doPostBack(\'ctl00$ContentPlaceHolder2$ucFormEDocumentRequest$FormEDocumentInformationUC$ddlCountry\',\'\')', 0)" id="ctl00_Conte...

try wb.Document.All.category.onchange() or wb.document.getElementById("CATEGORYID").value := 2402 wb.document.getElementById("CATEGORYID").onchange() I am new to ahk may be two months, and I am also stuck I got passed from this situation but I also need find the way to make ahk wait for element to g...

well I am new o ahk so far I have understand this wb.document.getElementByName("templatePK").value := 20049 ; for "Bilpaket" value 20049 wb.document.getElementByName("templatePK").onchange() ; i don't know how to make ahk to wait to elements to get loaded following code works, wait for web page to c...

I have a working code for drop down box to select countries, :dance: wb.document.getElementById("UC_ddlCountry").value := 840 wb.document.getElementById("UC_ddlCountry").onchange() wb.document.getElementById("UC_ddlCity").value := 735 .onchange() fire event and elements start loading, not the web pa...

personal.xlb defult destination is C:\Users\~username~\AppData\Roaming\Microsoft\Excel\XLSTART\ I am new to AHK and also don't have experience running macro from AHK, but through assigning shortkeys to macro then run from ahk. may be because excel run through ahk xl com don't load personal.xlb, you...

Now after some editing :idea: this code work for me :dance: #IfWinExist, ahk_class XLMAIN ^j:: XlApp := ComObjActive("Excel.Application") Text1 := XlApp.Range("au6").Value ;keyword is *123456* Text2 := XlApp.Range("au5").Value ;keyword is *1234-56* Text3 := XlApp.Range("au4").Value ;keyword is *1234...

Thank you so much Kon to reply me, this script is not working ,

I test it with debugger it seems after loop it jumps to "newestfile" which is empty

personal.xlb defult destination is C:\Users\~username~\AppData\Roaming\Microsoft\Excel\XLSTART\ I am new to AHK and also don't have experience running macro from AHK, but through assigning shortkeys to macro then run from ahk. may be because excel run through ahk xl com don't load personal.xlb, you ...

macro enabled file that contain macro should be active security pop enabled, or excel application having macro in personal.xlb should be active

I need to run a file from a specific location, though array 3 keywords, and want to open most recent file from loop. here is code ^j:: Sleep, 800 Xl := ComObjActive("Excel.Application") Text1 :=XL.Range("au4").Value ;keyword is *123456* Text2 :=XL.Range("au5").Value ;keyword is *1234-56* Text3 :=XL....

I am a newbie, it have been a mouth I know AHK, I have written MS Excel Macro that save as excel file to ahk extension then run it, script should be without trigger(shortkey). :D Excel Macro ___________________ Sub ScriptMaker() ' ' ScriptMaker Macro ' ' Keyboard Shortcut: Ctrl+y ' Range("B2").Selec...