Login via Excel

[rakupareek]

Hi
I want login incometax website via Excel directly
There are F1 is my login I'd and G1 is password
I want to open given website and fill Login Id and password automatic
Photo attached for your reference

 

[Logit]

Enter login and password on a web page from excel



Here is a way to do it using the sendkeys.

sub PageWeb ()
Dim IE As Object
Set IE = CreateObject ("internetexplorer.application")
IE.Navigate ("http://www.zaza.com/")
IE.Visible = True: IE.Top = 0: IE. Left = 0
IE.Width = GetSystemMetrics32 (0)
IE.Height = GetSystemMetrics32 (1)
Application.Wait Now +
5/3600/24 SendKeys ("loginZaza")
SendKeys "{TAB}"
SendKeys ("passwordzaza ~")
Application. Wait Now + 5/3600/24
Set IE = Nothing
Enter login and password on a web page from excel

 

[rakupareek]

Sub Login()
Dim Chromepath As String
Dim username As String, password As String
Chromepath = """C:\Program Files\Google\Chrome\Application\chrome.exe"""
Shell (Chromepath & "-url e-Filing Home Page, Income Tax Department, Government of India")


Application.Wait Now + TimeValue("00:00:05")
username = Worksheets("Login").Range("F1").Value
password = ThisWorkbook.Sheets("Login").Range("G1").Value
I AM USING THIS VBA CODE TO OPEN WEBSITE WHERE I WANT TO LOGIN BY USERNAME & PASSWORD
A CHECK BOX OPEN FOR CONFIRM SECURE LOGIN AFTER ENTRING USERNAME AND ENTER
AFTER TICK ON CHECK BOX PASSWORD WINDOW OPEN
THERE SHOULD BE LOGIN AT THIS WEBSITE AFTER ENTERING PASSWORD AND PRESS ENTER.
PLEASE HELP TO COMPLETE THIS CODE.

 

[rakupareek]

Thanks Logit
But I want to open this in Google crome

 

[Logit]

08-10-2022, 09:05 AM#5
mogul

Forum Contributor

Join Date02-25-2022LocationDallas, TexasMS-Off VerOffice 365Posts174

Re: Accessing password protected webpage in Google Chrome via VBA​

There is no standard way to login. You'll need to use Chrome's Development Tools to examine webpage and see how it is constructed. You can use Selenium to login. Selenium is a standard way to interact with webpages. There is a VBA COM Selenium addin you use called SeleniumBasic. You'll need to update Chromedriver for your version of Chrome. You need to have a basic understanding of HTML and CSS. Below is an example:

Attached Files

• 
  SeleniumLoginExample.xlsm‎ (17.0 KB, 11 views) Download

Accessing password protected webpage in Google Chrome via VBA