PDA

View Full Version : Solved: Open website by excel vba



clif
12-23-2012, 08:17 AM
Can open website by using excel vba?

patel
12-23-2012, 12:35 PM
yes

Aussiebear
12-23-2012, 02:33 PM
Here's something the Snb compiled

Sub internetlogon()
With CreateObject("InternetExplorer.Application")
.Navigate "http://enter web page here"
Do until .ReadyState = 4
DoEvents
Loop
DoEvents
With .document
.items("username")="******" 'Change to correct User Name
.items("usernamesend").submit
End With
End With
End Sub

clif
12-26-2012, 03:33 AM
Thanks!