![]() ![]() MyVar of course can be any valid name you like. You can do MyVar := Xl.Range("A2").Value to get the value out of an Excel cell and Xl.Range("A2").Value := MyVar to put a value into an Excel cell.Īnd then do something like wb.document.getElementById("globalSearchInput").value := MyVar. You do not even have to use the clipboard though, that is still thinking like a human would do it. Wb.document.getElementById("globalSearchInput").value := ClipboardĬlipboard is a built-in variable in AHK that always contains the contents of the Clipboard. You are wanting to assign the value of the Clipboard to something. You are not wanting to simulated the pressing of Control-V (paste). Send is a command that simulates the keystrokes of what is to follow. Right off wb.document.getElementById("globalSearchInput").value := Send ^v this does not look right. Staylo4 wrote:OK, first part down.IE opens and enters data and get's through sign on. Wb.document.getElementById("globalSearchInput").value := Send ^v ![]() WB := ComObjActive("InternetExplorer.Application") Xl.Range("A2").Copy copy cell to clipboard XL.Workbooks.Open("C:\Documents and Settings\staylo4\Desktop\P&G Auto Update COM") FileSelectFile, Path -(put 'Path' in below if you want to choose file) Wb.document.getElementById("globalSearchInput").value := Send ^v -Var has not been assigned WB := ComObjActive("InternetExplorer.Application") - Operation Unavail Moves to IE window from prior code and inputs A2 in 'globalSearchInput' I am SURE that I am trying to put too much into it but. This is the next part of my attempted code. OK, first part down.IE opens and enters data and get's through sign on. Wb.document.getElementsByTagName("login").Click() Wb.document.getElementById("Pswdfield").value := Password Wb.document.getElementById("Username").value := Loginname While wb.readyState != 4 || wb.document.readyState != "complete" || wb.busy wait for the page to load WB := ComObjCreate("InternetExplorer.Application") I have done a few net searches and using Tools/Dev in IE8.Īnyone help me out, or get me going in the correct direction? Wb.document.getElementsByTagName("login").Click() ERROR 0x80020006 - Unknown name Not able to find the SIGN IN button to click I am able to get the LOGINNAME to enter but I am not: ![]() OK, I am trying to learn some COM and I am having trouble in two spots. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |