Learn Excel - Video 598 - VBA - WEB SCRAPING

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

Рет қаралды 78,210

Күн бұрын

In this video we are doing log-in on a website using excel vba . I am educating you how to inspect the rags and web elements for login on a webpage.
Please see the below series information along-with links and join me in these world -class designed live classroom sessions. Bet. you will not be disappointed.
POWERPIVOT WITH DAX - PART1/2 (New Launched)
www.udemy.com/course/powerpiv...
POWERPIVOT WITH DAX - PART2/2 (Just Launched)
www.udemy.com/course/powerpiv...
LEARN DAX IN POWERBI DESKTOP - Part 1/2
www.udemy.com/course/learn-da...
LEARN DAX IN POWERBI DESKTOP - Part 2/2
www.udemy.com/course/learn-da...
POWER BI -BASIC TO ADVANCE PART 1 / 2 (New Course)
www.udemy.com/course/basic-to...
POWER BI -BASIC TO ADVANCE PART 2 / 2 (New Course)
www.udemy.com/course/basic-to...
Excel Power Query
www.udemy.com/course/excel-po...
Excel Power Query M Code Programming - Part 1
www.udemy.com/course/draft/26...
Excel Power Query M Code Programming - Part 2
www.udemy.com/course/powerque...
Excel Power Query M Code Programming - Part 3
www.udemy.com/course/powerque...
• [Excel VBA Series Links are mentioned below - basic to super advance]
Excel VBA Introduction Series 1
www.udemy.com/excel-vba-mis-a...
Excel VBA Loops and IF functions Sereis 2
www.udemy.com/excel-vba-loops...
Excel VBA Collection Loops and Workbook /Sheets handling Series 3
www.udemy.com/excel-vba-colle...
Excel VBA Super Strong Arrays Series 4
www.udemy.com/excel-vba-super...
Excel VBA Functions Series 5
www.udemy.com/excel-vba-funct...
Excel VBA File and Folder Handling Series 6
www.udemy.com/learn-excel-vba...
Excel VBA In depth UserForm Series 7
www.udemy.com/excel-vba-in-de...
Excel VBA error handler and Message box /input Box Series 8
www.udemy.com/error-handlers-...
Excel VBA Amazing and Phenomenal Events Series 9
www.udemy.com/excel-vba-amazi...
Excel VBA Awesome Pivots - Series 10
www.udemy.com/excel-vba-aweso...
Excel VBA Charts Series 11
www.udemy.com/excel-vba-chart...
Excel VBA Connecting Outlook Series 12
www.udemy.com/excel-vba-conne...
Excel VBA Connecting Powerpoint Series 13
www.udemy.com/excel-vba-conne...
Excel VBA Connecting MS Access - Series 14
www.udemy.com/excel-vba-conne...
Excel & Access VBA Dashboard and Projects - Series 15
www.udemy.com/advance-excel-a...
Web Scraping Using Excel VBA - Series 16
www.udemy.com/draft/2540898/?...
VBA Web Selenium Web Scraping Part 1/2
www.udemy.com/course/vba-sele...
VBA Web Selenium Web Scraping Part 2/2
www.udemy.com/course/vba-sele...
• [MS Access VBA Series]
Access VBA Introduction Series 1
www.udemy.com/access-vba-intr...
Access VBA Arrays and Functions Series 2
www.udemy.com/access-vba-arra...
Access Userform and SQL Series 3
www.udemy.com/access-vba-seri...
Access VBA File Handling and Error Handlers Series4
www.udemy.com/access-vba-file...
Connection Set-Up AccessVBA & Security (ADODB &DAO Series-5)
www.udemy.com/connection-stri...

Пікірлер: 180

@subashavr9396 4 жыл бұрын

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.

@supertotoro 3 жыл бұрын

Worked perfectly for me. Many thanks!

@germanduterte7110 5 жыл бұрын

This is very helpful I really appreciate this.

@cmsteib8564 5 жыл бұрын

Awesome video, thanks!

@sonammishra2964 4 жыл бұрын

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

@meirelles77 5 жыл бұрын

Very nice tutorial.

@enrikekasijas705 4 жыл бұрын

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 !!!!

@amitbond1 6 жыл бұрын

Superb...👌

@Exceltrixx 5 жыл бұрын

I Have no words...thank you so much

@AjayKumarparmar 5 жыл бұрын

thank you for your feedback. glad you liked it

@pablonji 3 жыл бұрын

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

@ayaanansari4765 5 жыл бұрын

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.

@vvcvillagersvoicecommunity9617 2 жыл бұрын

Great Job

@Raz0rtooth 3 жыл бұрын

you are a true brotendo

@Summerofsam 5 жыл бұрын

@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?

@keralakannapi2283 5 жыл бұрын

good vedio..helpfull

@shaghayeghrabbanian609 4 жыл бұрын

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

@psenpai3375 3 ай бұрын

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

@AjayKumarparmar 3 ай бұрын

Thanks a ton

@parveenrohilla02 5 жыл бұрын

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

@lhipad7372 4 жыл бұрын

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

@jmtiwari5766 5 жыл бұрын

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 ?

@MKMeena009 5 жыл бұрын

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

@sumeetshikha 4 жыл бұрын

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.

@antonyrinoy8996 3 жыл бұрын

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

@shiva11112 5 жыл бұрын

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

@zxc-xk6fb 4 жыл бұрын

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?

@mariuszkomenda3355 4 жыл бұрын

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

@drs10301 3 жыл бұрын

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

@thehalfknowledge 4 жыл бұрын

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

@maxdavenport6794 3 жыл бұрын

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?

@autoacworks 5 жыл бұрын

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

@audrianherdy8644 4 жыл бұрын

when i inspect element in login button there is no id

@unbelievabletalent 4 жыл бұрын

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

@devendrasingh521 3 жыл бұрын

How can we automat Edge without selenium

@akanshitachatterjee754 4 жыл бұрын

Can you show this for Google chrome instead of IE?

@bharadwajs2836 3 жыл бұрын

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

@supreetsidhu4732 5 жыл бұрын

How to do this in Firefox?please help

@vivekmahure88 2 жыл бұрын

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

@chidexxonyekwere9271 2 жыл бұрын

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

@AjayKumarparmar 2 жыл бұрын

Thank you sir

@kamranquliyev2296 4 жыл бұрын

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

@skymatrix554 4 жыл бұрын

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

@VipinKumar-dz2jn 2 жыл бұрын

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.

@systemcerdas3540 5 жыл бұрын

how to change browser internet explorer with chrome?

@MrAmitchirutkar 6 жыл бұрын

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

@AjayKumarparmar 6 жыл бұрын

Share website and data you using pls

@vstop2176 4 жыл бұрын

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.

@KuldeepSingh-nq1vi 4 жыл бұрын

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

@hrravihosur 4 жыл бұрын

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

@geovaniaraujo0515 4 жыл бұрын

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

@tpdakc7904 4 жыл бұрын

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

@varunbhardwaj8571 3 жыл бұрын

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

@erangaaw2542 6 жыл бұрын

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 6 жыл бұрын

Which website you using

@erickwang5850 2 жыл бұрын

@@AjayKumarparmar up

@AbhishekPatel-qe9xu 5 жыл бұрын

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

@JonerCVega 2 жыл бұрын

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

@AjayKumarparmar 2 жыл бұрын

Yeah via selenium VBA

@fengfuxu4822 2 жыл бұрын

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 2 жыл бұрын

Please share your code

@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 ajayk3802@gmail.com. I have to see code

@geovaniaraujo0515 4 жыл бұрын

the remote serve machine does not exist or is unavailable

@Funfreedomify 4 жыл бұрын

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

@erickwang5850 2 жыл бұрын

sama there have you found the solution?

@rajputshivambhai2518 3 жыл бұрын

error 438 on gst login portal help

@danelswick9886 8 ай бұрын

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 8 ай бұрын

Dear Danel, Vba selenium is a choice

@vishalpanchal9425 5 жыл бұрын

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

@AjayKumarparmar 5 жыл бұрын

share website which we can use with permission

@humbertomaturana2404 4 жыл бұрын

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 4 жыл бұрын

Use.value

@humbertomaturana2404 4 жыл бұрын

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

@AjayKumarparmar 4 жыл бұрын

Try inner text property

@VipinKumar-dz2jn 4 жыл бұрын

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

@AjayKumarparmar 4 жыл бұрын

For in depth knowledge you can purchase webscraping course from website

@patidarramesh5298 5 жыл бұрын

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

@AjayKumarparmar 5 жыл бұрын

What is website and doing what.

@abdul2000sg 2 жыл бұрын

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

@AjayKumarparmar 2 жыл бұрын

Sure

@rajanjha2392 2 жыл бұрын

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 2 жыл бұрын

You can purchase VBA selenium course

@damanpreet1131 5 жыл бұрын

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

@AjayKumarparmar 5 жыл бұрын

i will talk on this..

@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

@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

@erickwang5850 2 жыл бұрын

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 2 жыл бұрын

Thank you... can you please elaborate

@erickwang5850 2 жыл бұрын

@@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 2 жыл бұрын

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

@erickwang5850 2 жыл бұрын

@@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

@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

@fakhrullnoor4102 Жыл бұрын

Nice

@AjayKumarparmar Жыл бұрын

Thanks

@krish2519 6 жыл бұрын

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 6 жыл бұрын

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.

@pinkeishz9106 6 жыл бұрын

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 6 жыл бұрын

Ajay Kumar Sir, some help here?

@pinkeishz9106 6 жыл бұрын

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

@harvinder238 4 жыл бұрын

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

@AjayKumarparmar 4 жыл бұрын

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

@saleemmalik84 4 жыл бұрын

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

@AjayKumarparmar 4 жыл бұрын

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

@saleemmalik84 4 жыл бұрын

@@AjayKumarparmar on loop also giving the same error

@skinscapsfan 4 жыл бұрын

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

@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

@user-vg1zf8dn5m 2 ай бұрын

@@AjayKumarparmar up

@user-vg1zf8dn5m 2 ай бұрын

@@youknowme6780 you find solution ?

@ashrafanwar7835 6 жыл бұрын

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 6 жыл бұрын

I will check on this. Thanks for the compliment

@aaronb.7751 2 жыл бұрын

@@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 2 жыл бұрын

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

@aaronb.7751 2 жыл бұрын

@@AjayKumarparmar thank you!!

@Abhishekyadav-mo6py 4 жыл бұрын

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 4 жыл бұрын

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

@Naresh13Kumar 6 жыл бұрын

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 6 жыл бұрын

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

@Naresh13Kumar 6 жыл бұрын

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

@Naresh13Kumar 6 жыл бұрын

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

@donovannewton9507 11 ай бұрын

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

@AjayKumarparmar 11 ай бұрын

Use name tag or ID tag

@donovannewton9507 11 ай бұрын

@@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 11 ай бұрын

@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

@AnjanaNagpal-ej9by 2 ай бұрын

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

@AjayKumarparmar 2 ай бұрын

Use xpath attribute

@AnjanaNagpal-ej9by 2 ай бұрын

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

@gunwantsingh1698 5 жыл бұрын

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 5 жыл бұрын

Use selenium in vba then...

@gunwantsingh1698 5 жыл бұрын

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

@AjayKumarparmar 5 жыл бұрын

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 5 жыл бұрын

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

@peterkasonge7751 2 жыл бұрын

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 2 жыл бұрын

Use class attribute

@peterkasonge7751 2 жыл бұрын

@@AjayKumarparmar thanks Mr.

@peterkasonge7751 2 жыл бұрын

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 3 жыл бұрын

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

@AjayKumarparmar 3 жыл бұрын

Put a break in code..

@anishamalhotra6508 3 жыл бұрын

@@AjayKumarparmar Break how

@anishamalhotra6508 3 жыл бұрын

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

@tylerjensen7922 4 жыл бұрын

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 4 жыл бұрын

Is it opened in new page

@tylerjensen7922 3 жыл бұрын

@@AjayKumarparmar Yes.

@casimirouamusse9022 2 жыл бұрын

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

@Mr300millz 3 жыл бұрын

What if the button does not have an id

@Mr300millz 3 жыл бұрын

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 3 жыл бұрын

Use name attribute or class name

@chidexxonyekwere9271 2 жыл бұрын

Good job sir I want to know you more sir

@iAmStealty 3 жыл бұрын

What if username like this user_name

@bgupta77 6 жыл бұрын

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 6 жыл бұрын

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.

@vivekpachisia5198 2 жыл бұрын

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

@AjayKumarparmar 2 жыл бұрын

I should be an object

@vivekpachisia5198 2 жыл бұрын

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

@vivekpachisia5198 2 жыл бұрын

Correction New internetexplorer

@vivekpachisia5198 2 жыл бұрын

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

@parthokundu2578 3 жыл бұрын

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 3 жыл бұрын

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

@AjayKumarparmar 3 жыл бұрын

Different webpages behave differently many times..try send keys

@seepanmol554 4 жыл бұрын

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

@ranjitprakash1986 3 жыл бұрын

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

@AjayKumarparmar 3 жыл бұрын

You can use hammer but I am a peace lover

@James.Brooke 4 жыл бұрын

Superb 👏🏻👌🏻👍🏻

@chandankumar-np9ez 5 жыл бұрын

@aashraynalawade 4 жыл бұрын

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 3 жыл бұрын

@@aashraynalawade I want the same thing