Databases
StackOverflow2013
Postsdbo
POIE 9 not accepting SendKeys
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIE 9 not accepting SendKeys
    primarykey
    data
    text
    <p>I posted on <a href="https://stackoverflow.com/questions/11638933/excel-vba-sendkeys-not-causing-ie-9-to-save-download">IE 9 not accepting SendKeys to download a file</a>, but this problem is separate enough from the answer I received to justify another question. My problem is that I can't get IE 9 to accept any of the <code>SendKeys</code>. I have attempted <kbd>Page Down</kbd>, <kbd>Tab</kbd>, all of the <kbd>F#</kbd> keys, and none of them work. </p> <p>Here is the code I am using:</p> <pre><code>Dim ie As Object 'This creates the IE object Sub initializeIE() 'call this subprocedure to start internet explorer up Set ie = CreateObject("internetexplorer.application") pos = 1 End Sub 'Initialize the class object Private Sub Class_Initialize() initializeIE End Sub Function followLinkByText(thetext As String) As Boolean 'clicks the first link that has the specified text Dim alink As Variant 'Loops through every anchor in html document until specified text is found ' then clicks the link For Each alink In ie.document.Links If alink.innerHTML = thetext Then alink.Click 'waitForLoad Application.Wait Now + TimeValue("00:00:01") Application.SendKeys "{PGDN}", True Application.SendKeys "{PGUP}", True 'I've also tried calling it without Application before it SendKeys "{F1}", True SendKeys "{F2}", True 'Etc... Each of these not being received by IE 9 followLinkByText = True Exit Function End If Next End Function </code></pre> <p>I'm at a total loss because it seems like most forums or tutorials don't do anything different for IE 9. The IE object is created in a class module and initialized in the <code>Class_Initialize</code> sub. I am not sure if that helps any, but I really have no idea why this isn't working and any help on how to send keys to IE would be greatly appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USderigible
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIE 9 not accepting SendKeys
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CODo you have multiple tabs open? I have no experience automating IE9 specifically, but I have heard (can't find reference ATM) that this makes a difference.
      singulars
      1. POIE 9 not accepting SendKeys
      1. USGaffi
    2. CONo, the macro opens up only one instance of IE and only one tab. It only navigates to one URL so far.
      singulars
      1. POIE 9 not accepting SendKeys
      1. USderigible
    3. COThis may be a diversion from your actual question, but what are you trying to accomplish with `SendKeys`? Most operations can be done *without* it.
      singulars
      1. POIE 9 not accepting SendKeys
      1. USGaffi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload