Using VBA to complete pop-up form in IE

A

ANRoebuck

New Member
Joined
Nov 21, 2018
Messages
5
I'm trying to build a macro to go to a website, log in to an account, and retrieve data. The login form isn't on the web page as soon as it loads - you have to click a button first to make the form pop up. I'm getting an "object required" error message on the final line of the code below, even though I'm sure I have the correct object ID for the username field on the pop-up form.


Code: 
'Open IE and navicate to login page
Set IE = New InternetExplorer
IE.Visible = True
IE.navigate URL
Do Until IE.readyState = READYSTATE_COMPLETE: DoEvents: Loop




'Click login button to open form
Dim bLogIn As Object: Set bLogIn = IE.document.getElementById("SignInButton")
bLogIn.Click
Do Until IE.readyState = READYSTATE_COMPLETE: DoEvents: Loop




'Enter login info
IE.document.getElementById("username").Value = User


Inspecting the username field gives:

HTML: 
<input class="textbox" data-state="0" data-val-error-location=".error-summary.title" data-val-invokable="true" data-val-invokable-event="login-fail" data-val-login-fail-error="Something's not quite right; please try again." data-val-required="true" data-val-required-error="This is a required field." id="username" maxlength="80" name="username" rel="0" type="text" value="">


If it's helpful to look at the website in question, you can see that at the link below. Pressing "Sign in" in the top right corner brings up the login form.

https://www.wizards.com/Magic/PlaneswalkerPoints/


Any ideas what I'm missing? Any help would be very much appreciated!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
I'm not an expert in handling IE objects but it appears that pop up form is a frame. Do you need to reference the frame then the object?

When I ran your code the website gave an error saying the user site was down. But when I step through the code the login form appears. Weird.

I think the last line needs to look something like this:

IExplorer.Document.Frames("Enter frame name here").Document.getElementById("username").Value = User
or
IExplorer.Document.Frames("Enter frame name here").ContentDocument.getElementById("username").Value = User

It looks like the frame name is "samlWidget". I think the frame is an "iframe" - I'm unsure if that makes a difference or not....


 
Upvote 0
I've managed to identify where the box to enter the username is in the HTML - it's nested several layers deep. I've put each of the nested elements in the box below; each item in the list is nested within the one above, and it's the last item that I'm trying to isolate. I've managed to get it to select the first two, but anything deeper I'm having no luck with.


Code: 
******** id="wotcAccountWidgetModalIframe" src="https://accounts.wizards.com/Widget/ShowLogin?returnUrl=https%3A%2F%2Fwww.wizards.com%2FMagic%2FPlaneswalkerPoints%2F&requiredFieldSets=playlocation+name" class=" wotcWidget-modalIFrame" style="z-index: 1;">*********>
 
 
<html class="accounts-modal-html">
 
 
****** class="modal-body" >
 
 
<div class="modal">
 
 
<div class="modalFrame">
 
 
<div class="margin15Area">
 
 
<div class="modalContent">
 
 
<form id="loginForm" novalidate="">
 
 
<div class="control-container">
 
 
<div style="display: table;" class="textBoxHelpWrapper">
 
 
<input class="textbox" data-state="0" data-val-error-location=".error-summary.title" data-val-invokable="true" data-val-invokable-event="login-fail" data-val-login-fail-error="Something's not quite right; please try again." data-val-required="true" data-val-required-error="This is a required field." id="username" maxlength="80" name="username" rel="0" type="text" value="">
 
 
      ‘back at pink level
<div class="control-container">
 
 
<div style="display: table;" class="textBoxHelpWrapper">
 
 
        <input class="textbox" data-state="0" data-val-error-location=".error-summary.title" data-val-invokable="true" data-val-invokable-event="login-fail" data-val-login-fail-error="Something's not quite right; please try again." data-val-required="true" data-val-required-error="This is a required field." id="password" maxlength="29" name="password" rel="0" type="password" value="">



The code that seems to be happy picking out the first two layers is below.

Code: 
Set Doc1 = IE.document.getElementById("wotcAccountWidgetModalIframe")
    Set Doc1 = Doc1.document.getElementsByClassName("accounts-modal-html")(0)


Trying to isolate any of the other elements hasn't worked for me though and I'm not sure why.
 
Upvote 0
ANRoebuck said:
I've put each of the nested elements in the box below; each item in the list is nested within the one above, and it's the last item that I'm trying to isolate.
Click to expand...

I pasted more than I meant to - please ignore the last three elements in that box.

Also apparently you can't edit your posts on this forum?
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Getting 438 error while entering data on textbox on IE
Replies
0
Views
384
PuneetSingh1982
P
R
  • Question Question
VBA IE check and uncheck the checkbox with same-name and different-values "document of object iwebbrowser2 failed" error
Replies
0
Views
548
Ray_Dem
R
L
  • Question Question
Login used as a signature on a form
Replies
1
Views
451
Micron
M
J
  • Question Question
Login to a website using a macro and then click a button
Replies
3
Views
4K
jeremypyle
J
Akuini
  • Question Question
3 or More Dependent Data Validation, with VBA, easy to set up
3 4 5
Replies
47
Views
13K
xlsBruh
X

Forum statistics

Threads
1,223,911
Messages
6,175,322
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top