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.
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 !!!!
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
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
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.
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.
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?
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"
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?
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
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
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
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.
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
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
@@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
@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
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
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 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 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
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.
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.
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"
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 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.
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?
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
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!
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.
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
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.
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.
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?
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
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"
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.
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
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.
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.
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.
U r my best teacher
I am thankful to myself becoz of i found you
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 !!!!
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.
Dim idoc As MSHTML.HTMLdocument when i wrote this line , theree is an error . Compile error. User-defined type not defined
Excellent video!!!! I don't know how I didn't see it before !!! take your like (y)
Awesome video, thanks!
Great Job
Worked perfectly for me. Many thanks!
This is very helpful I really appreciate this.
Thank you! What should I do when my login button does not have name or id?
Thanks Man. Been a follower to your channel for a long time. Love from Kolkata.
Thanks a ton
Run time error
automation error
Unspecified error
[Set idoc = i.document]
Help-me pls
I'm from brazil
Very nice tutorial.
good vedio..helpfull
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
Dear Danel, Vba selenium is a choice
"Runtime error '430' class does not support Automation or does not support expected interface"???
I also have the same problem. did you get any solution?
Superb 👏🏻👌🏻👍🏻
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
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.
It's Wondefull, thank you for your videos, It's posible change to Navigator, for example chrome, edge???
Yeah via selenium VBA
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 ?
you are a true brotendo
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.
when i inspect element in login button there is no id
How to read and enter captcha along with login credentials... please help?
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?
Nice one boss I don’t mind to know you more
Thank you sir
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"
Please share your code
I Have no words...thank you so much
thank you for your feedback. glad you liked it
Hi,
Please help as I using ur code but doesn't Name and Id in there html document Input.
Hi Ajay, can show how to handle check box in VBA
Sure
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?
Share your code here or Gmail ajayk3802@gmail.com. I have to see code
@ajay I have a task Where in I have to login into website and post login click on different options
Can we automatically update data in an exel sheet from a table in a site which needs password login using this method?
Nice
Thanks
Can you show this for Google chrome instead of IE?
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
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?
hi, may I know is there anyway to get rid of "Missing credentials" error from web page while SCRAPING ?
what if the button doesnt have ID or value what should i input
sama there
have you found the solution?
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
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
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
If Security code option is shown on login page then what while we do?
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..
You can purchase VBA selenium course
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.
Which website you using
@@AjayKumarparmar up
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?
Use VBA selenium.. you can buy
How to write the tag is input for login process, how to write search bar in Amazon
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
Use vba selenium
How can we automat Edge without selenium
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
Hi ajay
If we have sha256 encription on client side in password. Then what to do??
TIA
Sirji services.gst.gov.in/services/login par ye work nahi karta .wi u plz help
the remote serve machine does not exist or is unavailable
Hi Sir, How can we download files using URL, pls make video on same..
I need like this , but I'm looking for VBA code from Access
So what do I do if my “log In” isn’t a button?
When I inspect the input I have the following.
== $0
Use name tag or ID tag
@@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
@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
I'm trying to click. A button on a web site but am unable to do so
The HTML code is
@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?
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
Share your code
@@AjayKumarparmar simple code to fill web with excel data.. And next page don't work....... Simple
@@AjayKumarparmar up
@@youknowme6780 you find solution ?
How to do this in Firefox?please help
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
Thank you... can you please elaborate
@@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!!
@@erickwang5850 you can share website and what you want to scrape
@@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
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.
How to ask user to enter the items from a list in excel to search on a website
Use xpath attribute
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
hi sir , i have multiple record in excel can we upload same on website and should be click automatic submit button .
Share website and data you using pls
I'm have issue at Set idoc = i.Document & I'm getting this msg "Automation error" & "Unspecified error" . Plz help me Ajay
Means website not loaded yet and VBA looking for it's document. Use do while not ready loop
how to change browser internet explorer with chrome?
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.
Use class attribute
@@AjayKumarparmar thanks Mr.
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"
How can go to any particular element in html page after login a website with username and password.
For in depth knowledge you can purchase webscraping course from website
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
I will check on this. Thanks for the compliment
@@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.
@@aaronb.7751 you have to use vba selenium for that.
@@AjayKumarparmar thank you!!
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?
Use.value
Thank for the quick reply @@AjayKumarparmar . I am using value -- idoc.all.UserName.Value = "username"
Try inner text property
Hi, I'm getting run-time error 462 remote server machine does not exist or is unavailable, at set idoc = i.document
Use loop.. Till site doesn't load it keeps looping
@@AjayKumarparmar on loop also giving the same error
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
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!
Is it opened in new page
@@AjayKumarparmar Yes.
run time error 462 the remote server machine dones not exist or is unavailable
Put a break in code..
@@AjayKumarparmar Break how
where i write a code as i.document in this code showing error @ajay kumar
error 438 on gst login portal
help
sir i try to file upload from web site using vba i fail much time..
pls help..
What is website and doing what.
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...
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.
Sir if we have list of username and password then how to login into same website and save time..
i will talk on this..
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
Use selenium in vba then...
@@AjayKumarparmar thanks for ur revert but ajay i dont know about selenium please guide me with proper instructions please
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.
@@AjayKumarparmar ok ajay thanks but i request you please make one video on this if possible...
What if the button does not have an id
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
Use name attribute or class name
Good job sir I want to know you more sir
Hi Ajay, Thanks for your tutorials. Could you please explain about the validation of the user credentials ?
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.
What you did so far send me. I will look into it and see if I can answer it
Ajay Kumar can I have Ur mail id to forward tha documents
Hi I have mailed u the documents can you please look in to that and can you please assist me
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
I don't know if we can use another element, but i use sendkeys "{enter}" and it works because the button has the focus.
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?
Ajay Kumar Sir, some help here?
My ele is blank hence it is not looping through...
For each ele in eles
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
What if username like this user_name
It is giving me an error on line Do While I READYSTATE_COMPLETE
Please help Sir
I should be an object
Shall we set I as an object. But it is set as new internet's poorer
How to resolve it?
Correction New internetexplorer
Error I am getting is
Run time error -2147417848
Automation error
The object invoked has disconnected from it's clients
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"
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.
Point noted.. Won't be repeated
@@AjayKumarparmar Sometimes we come to find solutions for one specific task. Hence, it's a good thing you explain. Thanks for that. Keep doing.
this code is only opening web page , not filling user details...i copied same your code
Different webpages behave differently many times..try send keys
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
How to destroy a keyboard while making a tutorial video ;)
You can use hammer but I am a peace lover
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.
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.
@@aashraynalawade I want the same thing
Superb...👌
How to choose any option from a drop down menu on a webpage using vba. Pls help
share website which we can use with permission