Vba Excel Login Help

[indhrui]

sir,
i have a more than 50 employees user name, password and dob, i want to check their details every day by entering the username, password and dob by manually,
i have listed the username, password and dob of the employees in one sheet

is there any excel vb codes to login this website https://incometaxindiaefiling.gov.in...LoginHome.html by automatically by clicking Command button for selected employee in another sheet. i done partly but i don,t no to how to solve it

Please help me

for details please see the attached file

[codeslizer]

Hi Indhrui,

In your codes, you just need to declare the "ie" object first. Rest of the code seems fine till you ask for DOB.

Please Login or Register  to view this content.

In the link, it has only username and password fields and no fields for DOB. I believe it should be after login then. If it is, you can again use the "IE.busy" clause again so that it waits till the IE gets the response and DOB field gets visible. You can proceed with further codes after this then.

Please Login or Register  to view this content.

Hope this helps!

[indhrui]

Thanks for your help in that website after entering the username, the dob will ask (it is hidden) than only i can login in the website. i am new to Vba, i collect all this from internet please help me.

[codeslizer]

Hey.. try to replace your code with this one.. I am unable to get through after entering the username - cause by the time I try moving to next code after entering the username, it pops me up with Invalid User.

Please Login or Register  to view this content.

Attached is the updated file.

[indhrui]

Thanks for codes,
sorry to say that i put a wrong username, now i changed the username please try with the first username and tell me how codes work, i tried that code but the it not showing date of birth field after entering the username

[indhrui]

I tried that code without this line ( ie.document.forms(0).submit) the dob is pasting like Fri Sep 16 00:00:00 UTC+0530 1977 for (16/09/1977) it should paste the dob in dd/mm/yyyy format than only i can login in the website, please help me how to solve it

[codeslizer]

Hmm.. I tried from my end. Says "Invalid Password". Also, it seems a little sensitive data - cause it relates with the Tax filings and stuffs. If you'd like to share the password, please message or mail it to me so that its not misused and if ever done, you know whose collar you'll need to catch..

Go to my profile : http://www.excelforum.com/members/codeslizer.html
and Send Private message on the left.

Also, I have a doubt too - The DOB, it's 4th July 1969 or 7th July 1969? I think its July but just wanted to make sure.

[codeslizer]

Well, you can change the code for DOB as

Please Login or Register  to view this content.

which would make sure that you're DOB is passed only in "dd/mm/yyyy" format

[indhrui]

Wooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo Great thanks that code works thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks Lot of thanks to you

[codeslizer]

Glad I could help!

Don't forget to mark the Thread as [Solved] and add Reputations if you find me helpful.