Excel vba auto log in to hdfc bank and downloading the bank statement

0 votes

we are trying to create a auto-login to https://netbanking.hdfcbank.com/netbanking/ but failed to pass the values to the text box

we tried with the code below but could not log in if any body please suggest what mistake I am doing it will be of great help to me.

Dim HTMLdoc As HTMLDocument
Dim oBrowser As InternetExplorer
Dim oHTML_Element As IHTMLElement
Dim sURL As String
sURL = "https://netbanking.hdfcbank.com/netbanking/"
Set oBrowser = New InternetExplorer

oBrowser.Silent = True
oBrowser.navigate sURL
oBrowser.Visible = True

Do 'Wait till the Browser is loaded...........................
Loop Until oBrowser.readyState = READYSTATE_COMPLETE
Set HTMLdoc = oBrowser.document

Sleep 2000

HTMLdoc.all("fldLoginUserId") = "45095398"
HTMLdoc.all("arcotsubmit").Click

Do 'Wait till the Browser is loaded...........................
Loop Until oBrowser.readyState = READYSTATE_COMPLETE
Jan 6, 2023 in Others by Kithuzzz
• 38,000 points
651 views

1 answer to this question.

0 votes
That page has a bunch of nested framesets which you'll need to sort out in order to solve this. Use the Developer tools in your browser to examine the structure of the page. I tried view source, but got a popup "Mouse right click disabled".
answered Jan 6, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

answered Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
1,791 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,600 points
14,776 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,600 points
861 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,254 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,694 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
960 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,084 views
0 votes
1 answer

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

answered Oct 27, 2022 in Others by narikkadan
• 63,600 points
1,043 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,600 points
1,156 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP