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

Share
Embed
  • Published on May 23, 2018
  • 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.
    If you thing channel is worth for some donation kindly visit my website www.excelvbalover.com and click on donation link.
    if you interested in learning or purchasing entire training on advance excel or excel vba or ms access or access vba please visit my website and click on purchase lcon. Dont forget to avail 37% discount coupon mentioned there.
    For any clarifications please email me at ajayk3802@gmail.com or whats app /call me at +919810375599
    Other options:-
    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.
    • [Excel VBA Series]
    Excel VBA Introduction Series 1
    www.udemy.com/excel-vba-mis-analytics-training/?couponCode=EXCELVBASERIES1

    Excel VBA Loops and IF functions Sereis 2
    www.udemy.com/excel-vba-loops-if-mis-analytics/?couponCode=AJAYLOOP001

    Excel VBA Collection Loops and Workbook /Sheets handling Series 3
    www.udemy.com/excel-vba-collection-loops-mis-analytics-training/?couponCode=AJAYCOLLECTION
    Excel VBA Super Strong Arrays Series 4
    www.udemy.com/excel-vba-super-strong-arrays/?couponCode=AJAYARRAYS

    Excel VBA Functions Series 5
    www.udemy.com/excel-vba-functions-mis-analytics/?couponCode=AJAYFUNCTIONS

    Excel VBA File and Folder Handling Series 6
    www.udemy.com/learn-excel-vba-files-and-folder-handling/?couponCode=AJAYFILESFOLDER

    Excel VBA In depth UserForm Series 7
    www.udemy.com/excel-vba-in-depth-userforms/?couponCode=AJAYVBFORMS

    Excel VBA error handler and Message box /input Box Series 8
    www.udemy.com/error-handlers-with-message-input-box/?couponCode=AJAYERROR001

    Excel VBA Amazing and Phenomenal Events Series 9
    www.udemy.com/excel-vba-amazing-and-phenomenal-events/?couponCode=AJAYEVENTS001

    Excel VBA Awesome Pivots - Series 10
    www.udemy.com/excel-vba-awesome-pivots/?couponCode=AJAYPIVOT
    Excel VBA Charts Series 11
    www.udemy.com/excel-vba-charts-bonus-3-surprise-tests-for-you/?couponCode=AJAYVBACHARTS

    Excel VBA Connecting Outlook Series 12
    www.udemy.com/excel-vba-connecting-outlook-application/?couponCode=AJAYOUTLOOK001
    Excel VBA Connecting Powerpoint Series 13
    www.udemy.com/excel-vba-connecting-powerpoint-application-series-13/?couponCode=AJAYPOWERPOINT
    Excel VBA Connecting MS Access - Series 14
    www.udemy.com/excel-vba-connect-with-ms-access-series-14/?couponCode=AJAYCONNECTACCESS

    • [MS Access VBA Series]
    Access VBA Introduction Series 1
    www.udemy.com/access-vba-introduction-series1/?couponCode=AJAYACCESSINTRO001
    Access VBA Arrays and Functions Series 2
    www.udemy.com/access-vba-arrays-and-functions-series-2/?couponCode=AJAYACCESSARRAY001

    Access Userform and SQL Series 3
    www.udemy.com/access-vba-series-3/?couponCode=AJAYACCESSFORMS001
    Access VBA File Handling and Error Handlers Series4
    www.udemy.com/access-vba-filefolder-handling-error-handler-s-series-4/?couponCode=AJAYFILES001
    Connection Strings ADODB and DAO Series 6
    www.udemy.com/connection-strings-ms-access-adodb-dao/?couponCode=AJAYCONNECTION
    Connect Excel using Access VBA Collection Loops - Series 7
    www.udemy.com/connect-excel-using-access-vba-collection-loops-series-7/?couponCode=AJAYACCESSCOLLECTION

    • (Advance Excel Series)
    Excel MIS Analytics Advance Vlookup,Match and IF Series 1
    www.udemy.com/complete-vlookup-match-cell-referencing-if-discussion/?couponCode=AJAYLOOKUP
    Excel Index Error Handlers and Text Functions Series 2
    www.udemy.com/excel-mis-anaylytics-training-series2/?couponCode=AJAYSERIES2

    Excel MIS Analytics Indirect Count and Sum family functions Series 3
    www.udemy.com/excel-mis-analytics-training-series3/?couponCode=AJAYINDIRECT001
    Excel MIS Training Advance Filter and Conditional Formatting Series 4
    www.udemy.com/excel-mis-analytics-series4/?couponCode=AJAYFORMATFILTER
    Excel Date OFFSET Charts ACTIVE-X and FORM Controls Series 5
    www.udemy.com/excel-mis-analytics-date-time-offset-charts-series5/?couponCode=AJAYOFFSET001


    • [MS Access (without VBA) Series]
    Introduction to Tables & Queries Series 1
    www.udemy.com/ms-access-table-and-queries-series-1/?couponCode=AJAYACCESSINTRO

    Sub Queries ,JOINS & Functions Series 2
    www.udemy.com/ms-access-sub-queries-joins-functions-series2/?couponCode=AJAYFUNCTIONS

    MS Access Forms Series 3
    www.udemy.com/ms-access-forms-series-3/?couponCode=AJAYFORMS
    MS Access Macros Series 4
    www.udemy.com/ms-access-macros-series-4/?couponCode=AJAYMACROS

Comments • 43

  • parveen rohilla
    parveen rohilla Month ago

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

  • Vishal Panchal
    Vishal Panchal 2 months ago

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

    • Ajay Kumar
      Ajay Kumar  2 months ago

      share website which we can use with permission

  • Sakthivel Vajjiravel
    Sakthivel Vajjiravel 3 months ago

    how can I get material from ajay

  • autoacworks
    autoacworks 3 months ago

    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

  • gunwant singh
    gunwant singh 3 months ago

    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

    • gunwant singh
      gunwant singh 3 months ago +1

      +Ajay Kumar ok ajay thanks but i request you please make one video on this if possible...

    • Ajay Kumar
      Ajay Kumar  3 months ago

      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.

    • gunwant singh
      gunwant singh 3 months ago

      +Ajay Kumar thanks for ur revert but ajay i dont know about selenium please guide me with proper instructions please

    • Ajay Kumar
      Ajay Kumar  3 months ago

      Use selenium in vba then...

  • shiva sankar
    shiva sankar 4 months ago

    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

  • ABHISHEK PATEL
    ABHISHEK PATEL 5 months ago

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

  • єитєятαιимєит - єитєятαιимєит - єитєятαιимєит

    I Have no words...thank you so much

    • Ajay Kumar
      Ajay Kumar  5 months ago

      thank you for your feedback. glad you liked it

  • Rafael Meirelles
    Rafael Meirelles 5 months ago +1

    Very nice tutorial.

  • PATUAKHALI ICT CLUB
    PATUAKHALI ICT CLUB 5 months ago

    Hello sir, How r u? is it possible to send or share excel data to other web application form automatically?

  • J M TIWARI
    J M TIWARI 5 months ago

    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 ?

  • amol dhaygude
    amol dhaygude 6 months ago

    Hi, your videos are very nice, I have one question to you. I have 50 lan printers I always login webpage and take tonner value and fill excel sheet and send it, could you please inform me how I use macro in this scenario.
    My email address is amoltofi@gmail.com

  • Cm Steib
    Cm Steib 8 months ago +1

    Awesome video, thanks!

  • Daman preet
    Daman preet 8 months ago

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

  • Mukesh Gaur
    Mukesh Gaur 8 months ago

    How to navigate from 1 to 10 pages in any particular websaite. Please make some videos for this also
    www.prnewswire.co.uk/news-releases/health-latest-news/medical-pharmaceuticals-list/

  • Naresh Kumar
    Naresh Kumar 11 months ago

    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.

    • Naresh Kumar
      Naresh Kumar 11 months ago

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

    • Naresh Kumar
      Naresh Kumar 11 months ago

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

    • Ajay Kumar
      Ajay Kumar  11 months ago

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

  • Auris Z
    Auris Z 11 months ago

    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?

    • Auris Z
      Auris Z 10 months ago

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

    • Auris Z
      Auris Z 10 months ago

      Ajay Kumar Sir, some help here?

  • Eranga Wijesekera
    Eranga Wijesekera 11 months ago

    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.

  • Ashraf Anwar
    Ashraf Anwar 11 months ago

    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

    • Ajay Kumar
      Ajay Kumar  11 months ago

      I will check on this. Thanks for the compliment

  • anand kumar
    anand kumar Year ago +1

    I recommend people to buy personal course materials from Ajay. I have purchased VBA macro course and it is really fantastic and very easy understanding with lots of examples. Well I am not just endorsing his products. But I can't stop my self to advise for buying the products if you are really interested

  • B Gupta
    B Gupta Year ago

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

    • Ajay Kumar
      Ajay Kumar  Year ago +1

      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.

  • Amit Chirutkar
    Amit Chirutkar Year ago

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

    • Ajay Kumar
      Ajay Kumar  Year ago

      Share website and data you using pls

  • Krish
    Krish Year ago

    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.

  • Amit Sharma
    Amit Sharma Year ago +1

    Superb...👌

  • Deepak Sharma
    Deepak Sharma Year ago +1

    wow !! awesome