sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
I have a spread I use daily where I need to go to a series of links on a site and extract data- all that is programmed
But it's a site that requires I first be logged into my account.
The above code works, but it opens up an IE window yada yada yada I'd just like it to log in in the background so I don't have to deal with a new window..
Is there a simple line I can add to this I'm not thinking of?
But it's a site that requires I first be logged into my account.
Code:
Sub AcctLogin()
Dim a As String
Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.navigate "https://www.nobama.com"
Do Until .readyState = 4
DoEvents
Loop
.document.all.Item("j_username").Value = "username"
.document.all.Item("j_password").Value = "password"
.document.forms(0).submit
End With
End Sub
The above code works, but it opens up an IE window yada yada yada I'd just like it to log in in the background so I don't have to deal with a new window..
Is there a simple line I can add to this I'm not thinking of?