How to input text into textbox of popup window displayed from webpage using excel vba

Asked Oct 27 '15 at 17:57

Active Oct 27 '15 at 18:14

Viewed 545 times

Using Excel/VBA, I'm trying to input text into a textbox that is displayed on a popup window. Here's the code defining the field I need to access:

span class="ui-helper-hidden-accessible" role="status" aria-live="polite"/>
input class="ui-autocomplete-input" id="RUItem" style="width: 100px;" type="text" autocomplete="off"/>

I tried using:

ie.Document.getElementById("RUItem").Value = "some-value"

But I get an error saying:

Object Required

so I know that I am not accessing it correctly. How do I input text into the secondary window?

edited Oct 27 '15 at 18:14

maxshuty

9,708
13
64
77

asked Oct 27 '15 at 17:57

VBAnewguy

You might need to use windows api? – findwindow Oct 27 '15 at 18:07
check out the accepted answer to this [post](http://stackoverflow.com/questions/17773523/handle-pop-up-while-navigating-with-ie). it may be useful. – Scott Holtzman Oct 27 '15 at 18:12
I've done this with an autoit application but not VBA. – MatthewD Oct 27 '15 at 18:37

How to input text into textbox of popup window displayed from webpage using excel vba

0 Answers0