Logging into a website using VBA
Hi All,
I am trying to login to a website using the code below. All the code is doing is opening the webpage and gives an error on 'While .Busy Or .ReadyState <> 4: DoEvents: Wend'. The error is a Run-time error ' -2147467259(80004005)' - Method 'Busy' of object 'IWebBrowser 2' failed.
Can I get some help on this please to make it work.
Please Login or Register to view this content.
Moderator Note:
Pls use code tags around your code next time as per forum rules.
Last edited by Fotis1991; 10-10-2013 at 09:16 AM.
I normally just use
can you load that webpage in your browser? Gives a timeout error for me.Please Login or Register to view this content.
well it may be because its a company's webpage but working fine with me. where shall I put the above code please?
I tried it but came up with a compile error on ' do events'
Replace your while statement with it. Do you get error for the first or the second readystate line in your code?
It is the first ready state please
Does this work?
Please Login or Register to view this content.
It does open the webpage but still with a run time error ' Object does not support this property' and it is for ' Do Until . readstate = 4'. and the form does not get filled in automatically. here is the HTML code from the website to give you an idea on tags.
<html>
<head>
<title>Zen Internet's Administration Server</title>
<link rel="stylesheet" href="/turing.css" type="text/css">
<style type="text/css">
<!--
table.user {
background-color: #c0f0c0;
color: #000000;
margin: 1px;
padding: 0px;
border-collapse: collapse;
border-spacing: 0px;
border-width: 1px;
border-style: solid;
border-color: #000000;
}
-->
</style>
</head>
<body bgcolor="#ffffff">
<center>
<form method="post" action="/Tools/usageviewer.php">
<table class="user">
<caption>Please Log In</caption>
<tr>
<th>Username:</th>
<td class="grey-l"><input type=text size=32 maxsize=32 name="user" value=""></td>
</tr>
<tr>
<th>Password:</th>
<td class="grey-bl"><input type=password size=32 maxsize=32 name="loginPassword" value=""></td>
</tr>
<tr>
<th color="#c0f0c0" colspan=2>
<input type=submit name="login" value="Login">
<input type=reset name="reset" value="Reset Details">
</td>
</tr>
</table>
</form>
<font color="red"><b></b></font>
</center>
</body>
</html>
Sorry, without the stupid mistakes this time (been a long day), does this work:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks