![]() 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
0 Comments
Leave a Reply. |