Learn Excel - Video 598 - VBA - WEB SCRAPING - How to Login on website

[@subashavr9396]

Bro this is an awesom video. It's really stunning and I m using this entire code as a part of my project. Thank you so much.

[@psenpai3375]

Thanks Man. Been a follower to your channel for a long time. Love from Kolkata.

[@AjayKumarparmar]

Thanks a ton

[@sonammishra2964]

U r my best teacher I am thankful to myself becoz of i found you

[@chandankumar-np9ez]

Thank you for the video. I have watched many of your videos. Please make on video on downloading files from a website after doing login on that website, navigate through many pages and selecting date for which need to download.

[@aashraynalawade]

Yes please do this....it's much needed to avoid lot of time. If this is done, people will get little time to spend with family instead of slogging in office just to login on the website navigate through pages n download the specific file.

[@salmansabir2644]

@@aashraynalawade I want the same thing

[@enrikekasijas705]

This is f*** insane xD I know almost nothing about VBA except Simple way of making macros but if this works....sick xD I need to study your channel.great explaining !!!!

[@shaghayeghrabbanian609]

Thank you! What should I do when my login button does not have name or id?

[@pablonji]

Excellent video!!!! I don't know how I didn't see it before !!! take your like (y)

[@vvcvillagersvoicecommunity9617]

Great Job

[@JonerCVega]

It's Wondefull, thank you for your videos, It's posible change to Navigator, for example chrome, edge???

[@AjayKumarparmar]

Yeah via selenium VBA

[@supertotoro]

Worked perfectly for me. Many thanks!

[@kamranquliyev2296]

Dim idoc As MSHTML.HTMLdocument when i wrote this line , theree is an error . Compile error. User-defined type not defined

[@cmsteib8564]

Awesome video, thanks!

[@chidexxonyekwere9271]

Nice one boss I don’t mind to know you more

[@AjayKumarparmar]

Thank you sir

[@danelswick9886]

I know this video is 5 years old but very good. How do we compensate that Internet Explorer has been replaced with Microsoft Edge. Also as asked prior what if the button inspection shows no ID only "class" Would love to move this to Chrome, but I'm just too old and retired to learn selenium

[@AjayKumarparmar]

Dear Danel, Vba selenium is a choice

[@jmtiwari5766]

Tthis is really useful. If the re is any captcha to be entered, how to go to the box where captcha is to be entered ?

[@VipinKumar-dz2jn]

Excellent video it help me a lot. Just have a query I have login a website where I have to track the invoice no. Status on website and save the details in pdf with invoice no. Name I'm stuck in to save the web page in pdf with invoice no. Please suggest what is the code should I refer.

[@sumeetshikha]

At last step of click to login, not able to find exact html tag shown in video. After clicking on Inspect element, html page opens highlighting below that other tags are coming which are not highlighted.

[@tpdakc7904]

"Runtime error '430' class does not support Automation or does not support expected interface"???

[@varunbhardwaj8571]

I also have the same problem. did you get any solution?

[@germanduterte7110]

This is very helpful I really appreciate this.

[@Raz0rtooth]

you are a true brotendo

[@thehalfknowledge]

Hey Ajay, Well Done!. I follow your instruction for google translation text is inserted and translated but I'm unable to copy the translated text because there is no ID, NAME elements how to copy the translated text, please tell me

[@fengfuxu4822]

when I ran the macro, the Edge closed by itself immediately after being loaded. do not know why? it also showed an info bar on top""Microsoft Edge is being controlled by automated test"

[@AjayKumarparmar]

Please share your code

[@abdul2000sg]

Hi Ajay, can show how to handle check box in VBA

[@AjayKumarparmar]

Sure

[@meirelles77]

Very nice tutorial.

[@keralakannapi2283]

good vedio..helpfull

[@rajanjha2392]

How to further go into the website which has drop down options? Can you pls help on this...? Thanks for such a nice video. Thanks in advance..

[@AjayKumarparmar]

You can purchase VBA selenium course

[@unbelievabletalent]

Hi, Please help as I using ur code but doesn't Name and Id in there html document Input.

[@vivekmahure88]

How to read and enter captcha along with login credentials... please help?

[@maxdavenport6794]

I'm getting "user-defined type not defined" what does this mean ? Also, once you've logged in to a website via this method, can you then scrape data from the website... how would this be done?

[@N0tAFed]

The input name for the login has $s in it which the VBA code doesn't seem to like. I tried changing them to underscores, but it the just fills the webpage username field with "undefined". What should I do?

[@AjayKumarparmar]

Share your code here or Gmail [e-mail]. I have to see code

[@bharadwajs2836]

@ajay I have a task Where in I have to login into website and post login click on different options

[@beautymahajan]

Hey really there was a lot to learn as u go step by step. Can u create a video to create the same using Firefox browser?

[@AjayKumarparmar]

Use VBA selenium.. you can buy

[@Exceltrixx]

I Have no words...thank you so much

[@AjayKumarparmar]

thank you for your feedback. glad you liked it

[@audrianherdy8644]

when i inspect element in login button there is no id

[@amitbond1]

Superb...👌

[@akanshitachatterjee754]

Can you show this for Google chrome instead of IE?

[@Funfreedomify]

what if the button doesnt have ID or value what should i input

[@erickwang5850]

sama there have you found the solution?

[@antonyrinoy8996]

Can we automatically update data in an exel sheet from a table in a site which needs password login using this method?

[@lhipad7372]

hi, may I know is there anyway to get rid of "Missing credentials" error from web page while SCRAPING ?

[@erangaaw2542]

Hi. Is there any method to copy data from a server application ( used in office day to day work) to an excel sheet? Example name , address field of a web based / server application which appears in the same place everyday.

[@AjayKumarparmar]

Which website you using

[@erickwang5850]

@@AjayKumarparmar up

[@makaniharesh1459]

Sirji services.gst.gov.in/services/login par ye work nahi karta .wi u plz help

[@shiva11112]

Hi Ajay, i was working on few internet explorer automation where i wanted to grab an internet explorer which is already opened and do some manipulation on that. But i am getting an automation error whenever i am trying to do that. Please suggest on any possible solutions

[@geovaniaraujo0515]

Run time error automation error Unspecified error [Set idoc = i.document] Help-me pls I'm from brazil

[@parveenrohilla02]

Hi ajay If we have sha256 encription on client side in password. Then what to do?? TIA

[@devendrasingh521]

How can we automat Edge without selenium

[@drs10301]

Dear Sir, what is the code for "waiting till webpage completely loads in chrome using excel vba" as it is "ie.readystate = readystate_complete" in internet explorer

[@skymatrix554]

How to write the tag is input for login process, how to write search bar in Amazon

[@zxc-xk6fb]

What if there is a placeholder on the username and pw fields? How do we remove the placeholders and replace it with our username and password?

[@Summerofsam]

@6:09 My excel does this sometimes too, seemingly for no reason. Do you know why it prompts error messages like this out of the blue?

[@vstop2176]

sir muje ek issue aa rah hay mare value put nahi ho rahi hay (services.gst.gov.in/services/login) ye web site per value put karke bataoo na sir plz req.

[@fifa193]

I used the code, but in ths website I want to access it has no effects, it set the username and password but then it doesn't access, I think it's related to the button, in fact the login button is not a "button" type, but a "submit" type, and there's also a Token I see in the code. So, what is the solution in this case with Token and "submit" button? Thanks

[@AjayKumarparmar]

Check sumbit button must have a attribute like ID or name. You can use that. And if not then it must be a form tag. So you can use same

[@MKMeena009]

If Security code option is shown on login page then what while we do?

[@geovaniaraujo0515]

the remote serve machine does not exist or is unavailable

[@youknowme6780]

I am working on a vba to fill web form, it works on first IE page and submit the form, but when a new page loads with different web address, my code don't recognize the active web page...to keep on filling this page data from excel...Any advice??? No selenium used

[@AjayKumarparmar]

Share your code

[@youknowme6780]

@@AjayKumarparmar simple code to fill web with excel data.. And next page don't work....... Simple

[@MoraTara]

@@AjayKumarparmar up

[@MoraTara]

@@youknowme6780 you find solution ?

[@panjabirang4814]

Hello sir i need you help to do same same task of many excel data. I mean i want to repeat same task for all disfrent id in excel sheet1. Ho how can i do this

[@AjayKumarparmar]

Use vba selenium

[@autoacworks]

hi, i have followed your excellent tutorial - how can i go to another page (automatically) after login is complete ..ex: I login to a website and then I want to go directly to my messages page

[@fakhrullnoor4102]

Nice

[@AjayKumarparmar]

Thanks

[@erickwang5850]

Hello sir , You have a really cool video, I managed to follow through all your step, how to get the data with query command with the vba? Thank you very much

[@AjayKumarparmar]

Thank you... can you please elaborate

[@erickwang5850]

@@AjayKumarparmar First of all thank you reply my comment,, i really appreciate it, I have a set of table in the website that i need to connect with my excel power query, but i dont know how to actually perform it via vba,, as far as i understand, i need more code on the same command (with the log in) to connect or import the data to my excel sheet Please pardon for my bad english Thank you sir!!

[@extremeautomationwithajayp2131]

@@erickwang5850 you can share website and what you want to scrape

[@erickwang5850]

@@extremeautomationwithajayp2131 i would love too but its a private company website so i cant share it, but i will come back with another close example,, thank you for replying to me , i really appreciate it and i'll definitely check your channel too

[@MrAmitchirutkar]

hi sir , i have multiple record in excel can we upload same on website and should be click automatic submit button .

[@AjayKumarparmar]

Share website and data you using pls

[@AbhishekPatel-qe9xu]

I'm trying to click. A button on a web site but am unable to do so The HTML code is

[@donovannewton9507]

So what do I do if my “log In” isn’t a button? When I inspect the input I have the following. == $0

[@AjayKumarparmar]

Use name tag or ID tag

[@donovannewton9507]

@@AjayKumarparmar thanks for that. It turned out the the element was an input not a button. Now im just trying to find out how to bring that into a table in excel. Thought there was a good option to use Power Query

[@AjayKumarparmar]

@donovannewton9507 check vba selenium..you can use . Power query is fine if you can see tables but programming has a lot to offer. You can customize. www.ajayparmartutor.com is my website if you need webscraping course or others

[@KuldeepSingh-nq1vi]

Hi Sir, How can we download files using URL, pls make video on same..

[@saleemmalik84]

Hi, I'm getting run-time error 462 remote server machine does not exist or is unavailable, at set idoc = i.document

[@AjayKumarparmar]

Use loop.. Till site doesn't load it keeps looping

[@saleemmalik84]

@@AjayKumarparmar on loop also giving the same error

[@skinscapsfan]

I had to make 2 changes to avoid 2 separate errors when I tried this. First, change the line "set i = New InternetExplorer" to "set i = New InternetExplorerMedium" (per StackExchange article 12965032). I also had to change the loop to: Do Until IE.ReadyState = READYSTATE_COMPLETE DoEvents Loop

[@mariuszkomenda3355]

I need like this , but I'm looking for VBA code from Access

[@supreetsidhu4732]

How to do this in Firefox?please help

[@harvinder238]

I'm have issue at Set idoc = i.Document & I'm getting this msg "Automation error" & "Unspecified error" . Plz help me Ajay

[@AjayKumarparmar]

Means website not loaded yet and VBA looking for it's document. Use do while not ready loop

[@vishalpanchal9425]

How to choose any option from a drop down menu on a webpage using vba. Pls help

[@AjayKumarparmar]

share website which we can use with permission

[@AnjanaNagpal-ej9by]

How to ask user to enter the items from a list in excel to search on a website

[@AjayKumarparmar]

Use xpath attribute

[@AnjanaNagpal-ej9by]

I m new to vba. Can u please provide code to automate searching datasheets for 100 components from a web site and filling data in excel sheet

[@systemcerdas3540]

how to change browser internet explorer with chrome?

[@ashrafanwar7835]

Hello, Love from you neighbor Pakistan. Have learned a lot from you. Thank you for teaching us. I want to know further is their possible way to use Microsoft Edge or Google Chrome instead of it? if yes please let me know (It would be appreciated too if you will make a video for it) or either please reply me back thanks

[@AjayKumarparmar]

I will check on this. Thanks for the compliment

[@aaronb.7751]

@@AjayKumarparmar hi, I was wondering if you ever figured out how to do this with Chrome or Edge instead of Internet Explorer? Thank you - you have great content.

[@AjayKumarparmar]

@@aaronb.7751 you have to use vba selenium for that.

[@aaronb.7751]

@@AjayKumarparmar thank you!!

[@rajputshivambhai2518]

error 438 on gst login portal help

[@humbertomaturana2404]

Hi Ajay, Many thanks for your tutorial, very helpful. I was able to add the username and password in the website but I am getting "This field can not be left in blank" error on the username when the Submit processes. Any idea what could be happening?

[@AjayKumarparmar]

Use.value

[@humbertomaturana2404]

Thank for the quick reply @@AjayKumarparmar . I am using value -- idoc.all.UserName.Value = "username"

[@AjayKumarparmar]

Try inner text property

[@peterkasonge7751]

bro I like this video. but i have a problem to use hyper links. if I inspect a button element it give me the following html code .please help me on how to work with this sort of reference. . there is nothing like input type , id or name. so please help.

[@AjayKumarparmar]

Use class attribute

[@peterkasonge7751]

@@AjayKumarparmar thanks Mr.

[@peterkasonge7751]

but I still have problem because there are three buttons with the same class name, the only there different is the href"/Main/DashBoard?grade=3" , href"/Main/DashBoard?grade=4" and href"/Main/DashBoard?grade=5"

[@anishamalhotra6508]

run time error 462 the remote server machine dones not exist or is unavailable

[@AjayKumarparmar]

Put a break in code..

[@anishamalhotra6508]

@@AjayKumarparmar Break how

[@anishamalhotra6508]

where i write a code as i.document in this code showing error @ajay kumar

[@Mr300millz]

What if the button does not have an id

[@Mr300millz]

Just tweaked the code Set eles = idoc.getElementsByClassName("btn btn-primary") For Each ele In eles If ele.Type = "submit" Then ele.Click Else End If Next ele

[@AjayKumarparmar]

Use name attribute or class name

[@chidexxonyekwere9271]

Good job sir I want to know you more sir

[@casimirouamusse9022]

Não sou bom a inglês, No entanto este vídeo é muito didático simples e útil. Parabéns. Produza um outro mas usando outros navegadores como Firefox, Chrome ou Edge. Aguardo por si

[@tylerjensen7922]

Have any of you had the following errors? I watched the video and found it very helpful. I was able to use the code to log in to the desired website. My code was something like this: idoc.all.name1.value = "username" idoc.all.name2.value = "Password" idoc.all.name100_Login_Button.click I am now logged on the website my next line of the code is idoc.all.name3.value = "Search Criteria" which is for the search criteria and it doesn't work My excel doc doesn't upload search criteria but doesn't have an error. I was wondering if you have any of you have had this error or feedback that could help. Thanks!

[@AjayKumarparmar]

Is it opened in new page

[@tylerjensen7922]

@@AjayKumarparmar Yes.

[@bgupta77]

video is nice but would request you to kindly change your keybord it makes lot of sound which distract the mind while working on it...

[@AjayKumarparmar]

it gives a feel that you are having a live session. Many students love to have this sort of environment. When you see lecture feel like you are typing it and giving training, you will enjoy it.

[@patidarramesh5298]

sir i try to file upload from web site using vba i fail much time.. pls help..

[@AjayKumarparmar]

What is website and doing what.

[@hrravihosur]

Hi Ajay, Thanks for your tutorials. Could you please explain about the validation of the user credentials ?

[@gunwantsingh1698]

Hi Ajay first of all thanks for this. Can i used this macro with google crome means i want open my web page in google crome .please revert its realy helpfull for me

[@AjayKumarparmar]

Use selenium in vba then...

[@gunwantsingh1698]

@@AjayKumarparmar thanks for ur revert but ajay i dont know about selenium please guide me with proper instructions please

[@AjayKumarparmar]

Selenium is a web testing software but if you know this language you can use it in excel vba also to launch Google Chrome explorer. You can search on Google to know more about it.

[@gunwantsingh1698]

@@AjayKumarparmar ok ajay thanks but i request you please make one video on this if possible...

[@krish2519]

Hi Ajay... thank you for your videos and I'm interested to watch your videos regularly. When you are uploading a series of videos about a specific topic. Its better don't repeat same basics again again in every video.

[@AjayKumarparmar]

Point noted.. Won't be repeated

[@ManishAnand1365]

@@AjayKumarparmar Sometimes we come to find solutions for one specific task. Hence, it's a good thing you explain. Thanks for that. Keep doing.

[@damanpreet1131]

Sir if we have list of username and password then how to login into same website and save time..

[@AjayKumarparmar]

i will talk on this..

[@Naresh13Kumar]

Hi Ajay - I need assistance on webpage scrapping. This is tha scenario. I have to update a information for the users and need to give save in website I done VBA everything till updating the information. But here I face one issue that after giving save page displays with tha alert box which only have ok option to click I tried different types I'm not able to get the idea to click this alert box. Can you please help? With the code.

[@AjayKumarparmar]

What you did so far send me. I will look into it and see if I can answer it

[@Naresh13Kumar]

Ajay Kumar can I have Ur mail id to forward tha documents

[@Naresh13Kumar]

Hi I have mailed u the documents can you please look in to that and can you please assist me

[@vivekpachisia5198]

It is giving me an error on line Do While I READYSTATE_COMPLETE Please help Sir

[@AjayKumarparmar]

I should be an object

[@vivekpachisia5198]

Shall we set I as an object. But it is set as new internet's poorer How to resolve it?

[@vivekpachisia5198]

Correction New internetexplorer

[@vivekpachisia5198]

Error I am getting is Run time error -2147417848 Automation error The object invoked has disconnected from it's clients

[@pinkeishz9106]

Hello Sir, Great video 👍 I'm facing error on do while ... Error message: Automation error The object invoked has disconnected from its clients. Could you please help?

[@pinkeishz9106]

Ajay Kumar Sir, some help here?

[@pinkeishz9106]

My ele is blank hence it is not looping through... For each ele in eles

[@Abhishekyadav-mo6py]

thank you for making this video sir I want to know can we use another element instead of I'd in button case for clicking the button

[@bentoazevedo1484]

I don't know if we can use another element, but i use sendkeys "{enter}" and it works because the button has the focus.

[@iAmStealty]

What if username like this user_name

[@parthokundu2578]

How to use colon ":" in controls example .....refer last statement Dim idoc As MSHTML.HTMLDocument Set idoc = i.document idoc.all.loginForm:username12.Value = "XXXXX"

[@himmatsingh5350]

this code is only opening web page , not filling user details...i copied same your code

[@AjayKumarparmar]

Different webpages behave differently many times..try send keys

[@ranjitprakash1986]

How to destroy a keyboard while making a tutorial video ;)

[@AjayKumarparmar]

You can use hammer but I am a peace lover

[@seepanmol554]

Brother error is Debug Username password. Let me send you elements of the username password and button, ------------------- ------------------- Log In ------------------- Please let me know what should i put . i want to import this side to my excel. And wants to see all changes every minute while refreshing my excel

[@ayaanansari4765]

Thank you for the video. I have watched many of your videos. Please make on video on downloading files from a website after doing login on that website, navigate through many pages and selecting date for which need to download.

[@James.Brooke]

Superb 👏🏻👌🏻👍🏻

[@VipinKumar-dz2jn]

How can go to any particular element in html page after login a website with username and password.

[@AjayKumarparmar]

For in depth knowledge you can purchase webscraping course from website